Subject Re: [IBO] Uploading a table
Author Geoff Worboys
> Could someone explain this difference ? Thanks

When you have "where 0=1" the processing is short because there is no
result set so a refresh takes little time (although it will still take
some). It sounds like your TIBOQuery has some keylinks problems which
means that a refresh of the inserted record is taking more time that
it should. But regardless of the problems with your TIBOQuery...

Do the inserts using a separate component (TIB_DSQL or TIBOUpdateSQL).
If you need to see the results in the TIBOQuery at the end, simply
refresh the query when the insert processing has completed.


Geoff Worboys
Telesis Computing