Hello Gardner!

I have no idea why TIBOQuery.Open appears to hang. It may well be an
obscure error that Jason would want to eliminate. What puzzles me is your
use of TIBOQuery for inserts. Surely, using a parameterized TIB_DSQL would
be much better?

I.e. use SQL like INSERT INTO GARDNERTABLE(FIELDA, FIELDB) VALUES (:VALUEA,
:VALUEB), prepare the DSQL, and start looping calling Params[] or
ParamByName() followed by Execute or ExecSQL. Then - after looping or at
set intervals of some thousands - call commit for your TIB_Transaction.

HTH,
Set

>Hello,
> I have written a data migration utility that maps and moves data from a
>paradox database into an interbase database. I use TTable's and TQuery's to
>access the paradox data and IBO to insert the data into an Interbase 6
>database. After a lot of processing and TIBOQuery.Open and TIBOQuery.Closes
>my application stops on TIBOQuery.Open while it is issuing a 'select * from
>table' query. The CPU is using 0% on the db server as well as the machine
>that is running the application. What could cause the .Open call to never
>return?
>Any input is appreciated. (including spelling corrections and improper use
>of grammar or punctuation ;)