Zeos and data update
lazarus / 16-Databases

----------------------------------------------------------------------
xinyiman · 2016-03-13 16:21

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 · 2016-03-14 10:22

no idea?

----------------------------------------------------------------------
dogriz · 2016-03-15 11:26

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 · 2016-03-15 11:44

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

----------------------------------------------------------------------
dogriz · 2016-03-15 12:32

Quote from: Soner A. on March 15, 2016, 12:44:52 pmYou 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 · 2016-03-16 08:09

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.