Subject RE: [IBO] IBOQuery with record locking
Author Jason Wharton
It sounds like what you are asking for is a dirty read.
This is not something that InterBase or Firebird allows.
This is also something that is not desirable.
If you want another user to be able to see changes from another user then
they have to be committed and in a tiCommitted isolation.

Jason Wharton

> -----Original Message-----
> From: []On
> Behalf Of earnesttse
> Sent: Wednesday, March 19, 2008 7:01 PM
> To:
> Subject: [IBO] IBOQuery with record locking
> Hello, I have a record locking problem needing your help!
> I have master/detail tables to record sale invoice. I call
> IB_Database.StatTransaction before editing master reocrd. When one
> user is editing a record of detial, other user can't read the edited
> record, system will wait until the record has been cancelled or
> posted.
> Is there any way to allow the second user to view the edited record
> without waiting the first user completed editing?
> I read the book of Helen: The Firebird Book. I found that in page
> 552: In Firebird, all updates are at row level ... When a transaction
> submits a request to update a row; the old version of that row
> remains visible to all transactions. Writers do not block readers.
> Is there anything I missed?
> I am using Delphi 2007, IBO 4.8.7, IBOQuery, AutoCommit=True,
> Isolation=tiCommitted.
> Your prompt reply is highly appreciated!
> Thanks for help!
> Earnest