Lazarus

Programming => Databases => Topic started by: xinyiman on March 13, 2016, 05:21:30 pm

Title: Zeos and data update
Post 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?

Title: Re: Zeos and data update
Post by: xinyiman on March 14, 2016, 11:22:32 am

no idea?

Title: Re: Zeos and data update
Post by: dogriz on March 15, 2016, 12:26:30 pm

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).

Title: Re: Zeos and data update
Post by: SunyD on March 15, 2016, 12:44:52 pm

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

Title: Re: Zeos and data update
Post by: dogriz on March 15, 2016, 01:32:44 pm

Quote from: Soner A. on March 15, 2016, 12:44:52 pm

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".

Title: Re: Zeos and data update
Post by: mangakissa on March 16, 2016, 09:09:36 am

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.