Page 1 of 1

Using Zeos / Firebird - Why cant other users see new data?

Posted: 21.11.2006, 04:51
by davidb
Hi,

Could you please help me. I am using Delphi / Zeos / Firebird

If I have multible users connected, the users cannot see changes
to the database until the Connection is discoonected.
I am using Commit etc after post.

I thought that by Closing and Openeing the database would refresh
the records, but this seems not to be the case,

Can I keep the connection active and refresh the database so that
all users can see the updates when refreshed?

Thanks very much

Posted: 21.11.2006, 12:42
by gto
Try change the Transaction Isolation Level, a property of the TZConnection object. It specify how concurrent users will see the changes of each other. Try with tiReadCommited, it should work for you.

[]'s

Posted: 22.11.2006, 01:00
by davidb
Perfect - Thank you very much, worked a treat.