Board index » delphi » REQ: Insert records in Interbase table from Paradox table

massi4...@my-deja.com

Delphi Developer
Sat, 21 Jun 2003 21:55:56 GMT

REQ: Insert records in Interbase table from Paradox table

I'm trying to insert all the records of a paradox table into a
Interbase table, using batchmove or this SQL instruction

insert into ":IBDB:Movement" select * from ":PXTB:tempTbl.db"

but is very slow, there is a fast way to do this ?

thanks in advance

Sent via Deja.com
http://www.deja.com/

 

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:REQ: Insert records in Interbase table from Paradox table


M.H. Avegaar

Delphi Developer
Tue, 24 Jun 2003 20:34:57 GMT

Re:REQ: Insert records in Interbase table from Paradox table


This is slow, because all records are moved from the Paradox database to the
BDE and from the BDE to the Interbase database. You could increase the speed
if Paradox would be able to store records in an Interbase database or if
Interbase would be able to read Paradox records (thereby avoiding the BDE).
Unfortunately neither Paradox nor Interbase support this...

<massi4...@my-deja.com> schreef in bericht
news:92smla$ros$1@nnrp1.deja.com...

Quote
> I'm trying to insert all the records of a paradox table into a
> Interbase table, using batchmove or this SQL instruction

> insert into ":IBDB:Movement" select * from ":PXTB:tempTbl.db"

> but is very slow, there is a fast way to do this ?

> thanks in advance

> Sent via Deja.com
> http://www.deja.com/

Davi

Delphi Developer
Sun, 13 Jul 2003 01:06:51 GMT

Re:REQ: Insert records in Interbase table from Paradox table


Hi,

I have just done that but used hard code and tables... what happens with
batch move if the paradox field is of type Boolean or integer?

Regards

Dave

Quote
<massi4...@my-deja.com> wrote in message news:92smla$ros$1@nnrp1.deja.com...
> I'm trying to insert all the records of a paradox table into a
> Interbase table, using batchmove or this SQL instruction

> insert into ":IBDB:Movement" select * from ":PXTB:tempTbl.db"

> but is very slow, there is a fast way to do this ?

> thanks in advance

> Sent via Deja.com
> http://www.deja.com/

Other Threads

1. Retrieving the last inserted record from Paradox-table

2. Paradox records are not inserted into table permanently, abnormal shutting down makes data lost

3. todays date posted into a paradox table or interbase table

4. REQ: info about using Paradox Tables on a local Network

5. retreining the last inserted record from a table

6. Insert BLOB field in Interbase Table

7. How to insert records into indexed MS-SQL-Tables with Delphi C/S

8. Canceling: insert records in detail table ?

9. Problem when inserting records in the detail table (master/detail relation)

10. Detail Table Won't Insert New Record!?!?