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

[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

[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

[davidb]

Perfect - Thank you very much, worked a treat.