Zeos and data update

[xinyiman]

Hello guys, will be old age but I do not remember how I Zeos to say to a connection you want to see all changes automatically applied by other users. So if another user changes me from under the nose of the data I want to know right away to prevent not to notice.

Who refreshes my memory?

[xinyiman]

no idea?

[dogriz]

I dont' think that can be done automatically. My guess is that it depends on database architecture and your implementation. I use ZIBEventAlerter with firebird database (two-tier - client/server architecture).

[SunyD]

You have only one to do, set for your TZConnection:
ZConnection1.TransactIsolationLevel:= tiReadCommitted;

[dogriz]

You have only one to do, set for your TZConnection:
ZConnection1.TransactIsolationLevel:= tiReadCommitted;

Yes, but not quite. Doing only that, he won't be able to "see all changes automatically applied by other users".

[mangakissa]

No, because your dataset is cached in memory. You have to refresh your datasets to see all changes. That's your problem. You need a trigger to refresh your data.

Why want you do that. I only imagine a screen with all data opened all the time with the latest changes in records.