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.

HTH

Geoff Worboys
Telesis Computing