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) ?
Data refreshing
Moderators: gto, cipto_kh, EgonHugeist
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
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
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