Page 1 of 1
Data refreshing
Posted: 06.01.2007, 21:18
by jorgen
I'm testing ZEOS 6.6 with Firebird 2.0 and noticed that in both Delphi 7 and Delphi 2006 data changes comitted by other clients are not updated in application (either by zquery.refresh or repeating a query) until I disconnect from database in ZConnection and connect again.
What should I do to get updated data without having to reconnect (works fine with mysql) ?
Posted: 07.01.2007, 15:02
by mdaems
Can it have something to do with the transaction isolation level?
I think as long as you are in a transaction with repeateable read transaction isolation level you don't see the other updates. So you could try with a commit before refreshing/requerying or use another isolation level. Mysql does not support all levels for all table types, so that could explain why it works there.
Finally: I can be completely wrong...
Mark
Posted: 08.01.2007, 15:56
by jorgen
Allright, changing isolation level solved both my problems (refreshing and the other one I had with deadlock).
Thank you, very much.