How to commit and refresh

duzenko · Post by **duzenko** » 17.06.2009, 11:32

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?

duzenko · Post by **duzenko** » 17.06.2009, 12:01

google rules

http://firebird-with-delphi.blogspot.co ... d-ado.html

that helped

delphi2pk · Post by **delphi2pk** » 17.06.2009, 12:49

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.

guidoaerts · Post by **guidoaerts** » 01.07.2009, 16:15

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?

delphi2pk · Post by **delphi2pk** » 02.07.2009, 04:45

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.

guidoaerts · Post by **guidoaerts** » 03.07.2009, 16:11

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.