Subject RE: [IBO] Preventing Refresh with IBOQuery
Author Claudio Valderrama C.
> -----Original Message-----
> From: rnagle@... [mailto:rnagle@...]
> Sent: Martes 6 de Marzo de 2001 13:15
> The problem I am having is that the inserts from qryTarget are
> appearing in qrySource and the program is going into an infinite loop
> (well, untill the hard disk fills up anyway).
> Is there are anyway I can prevent my inserts from appearing in
> qrySource?

Bind the source query to a txn with isolation tiConcurrency and bind the
target query to a transaction with isolation tiCommitRetaining. Start the
two txns, do your procedure and commit the txns.
- TIB_Datapump is for those tasks but in this case you can fall in the same
- Maybe you will go slightly faster replacing the target query by a TIB_DSQL

> I know I could do INSERT INTO....SELECT FROM... but for various
> reasons I don't want to do it this way.

You can't do that because you will get into an infinite loop. It's a
shortcoming in IB. See