Search found 2 matches
- 27.12.2018, 14:53
- Forum: Firebird
- Topic: Design issue: How to get always fresh data with Zeos TZConnection and TZQuery (in AutoCommit mode)?
- Replies: 2
- Views: 3101
Re: Design issue: How to get always fresh data with Zeos TZConnection and TZQuery (in AutoCommit mode)?
Merci! Setting TZConnection TransactionIsolationLevel property to tiReadCommitted and AutoCommit to true solved my problem. Ineed, I am always using ReadCommited for my TIBTransaction as well and now I wonder why I didn't set it for TZConnection from the start as well.
- 27.12.2018, 09:18
- Forum: Firebird
- Topic: Design issue: How to get always fresh data with Zeos TZConnection and TZQuery (in AutoCommit mode)?
- Replies: 2
- Views: 3101
Design issue: How to get always fresh data with Zeos TZConnection and TZQuery (in AutoCommit mode)?
I have Delphi application with TZConnection in AutoCommit mode (connecting to the Firebird 3.0) in the global DataModule, this single connection serves all the queries in all the datamodules of the application. But I have the problem, that the queries see only the data that were committed during the...