Svein,
Excellent suggestion. At this point we're not able to spend any more
development time altering the applications methods. We have spent too much
development time to date. I have installed the latest IBO and I free and
reallocate the IDOQuery on the same interval that I commit the xaction. The
behavior has subsided, although I hate to close a bug without determining
what exactly causes it.

I will keep your TIB_DSQL suggestion in mind for future applications.

Cheers,
Gardner


-----Original Message-----
From: Svein Erling Tysvær
[mailto:svein.erling.tysvaer@...]
Sent: Friday, July 12, 2002 1:00 AM
To: ibobjects@yahoogroups.com
Subject: Re: [IBO] TIBOQuery.Open hangs indefinitely.


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 ;)

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/