Page 1 of 1

How to commit and refresh

Posted: 17.06.2009, 11:32
by duzenko
I have two applications and I need each one to be able to get data that another app has posted. And I can not get it.

I have created a sample program that demonstrates my problem - run two instances of it

When I change data in one instance, I can't see changes in another until program restart. Dataset close/reopen won't help

ZConnection.Autocommit = true

Can anyone tell what am I doing wrong?

Posted: 17.06.2009, 12:01
by duzenko

Posted: 17.06.2009, 12:49
by delphi2pk
Set TransactionIsolationLeve := tiReadComitted

now data will be updated on pressing navigators refresh button.

you don't worry about comitting the transaction.... thats all about zconnection.

Posted: 01.07.2009, 16:15
by guidoaerts
I have a similar problem, and just refreshing won't work

delphi5, fb 2.1.2, zeoslib 6.6.4, tiReadCcommitted
ZTable1.refresh doesn't reflect the changes made by the same agenda application from another pc on my network

any tips?

Posted: 02.07.2009, 04:45
by delphi2pk
guidoaerts wrote:I have a similar problem, and just refreshing won't work

delphi5, fb 2.1.2, zeoslib 6.6.4, tiReadCcommitted
ZTable1.refresh doesn't reflect the changes made by the same agenda application from another pc on my network

any tips?
I think zeos 6.6.4 is not fully supporting fb 2.1.2
use zeos 6.6.5 instead.

Posted: 03.07.2009, 16:11
by guidoaerts
delphi2pk wrote: I think zeos 6.6.4 is not fully supporting fb 2.1.2
use zeos 6.6.5 instead.
I installed zeos 6.6.5, now refresh works, but only after repeatedly refreshing (5..6 times), would it be better to step down to fb 1.5?

Correction, it works fine now, my problem was lying with the refreshing of another component.
tx.