Lazarus
Programming => Databases => Topic started by: xinyiman on March 13, 2016, 05:21:30 pm
-
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?
-
no idea?
-
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).
-
You have only one to do, set for your TZConnection:
ZConnection1.TransactIsolationLevel:= tiReadCommitted;
-
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".
-
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.