On Tue, 18 May 2004 11:56:51 +0000 (UTC), Max Bernaert wrote:

> After doing several inserts in a table. The new records seems not to be
> available in my Delphi programs until I fully exit the program.
> Even after an active := false followed by an active := true the data is
> not visible.
> The data is only visible if I alter the sql sentence of the TIBOQuery.
> What I am doing wrong ?
> Thanks for your help.

Are you talking about 'not being able to see the data from another
programs' or 'in the same program'?
Unless other programs use a ReadCommitted transaction they need to start a
new transaction to see committed data.
Restarting a program starts a new transaction and so ...


--
Aage J.