Hello Martijn,

MT> Actually, not Delphi... But I guess you mean "IBX". I don't think IBO
MT> does a CommitRetaining unless you tell it to. How about FIB+?
AFAIK, the recommended practice for FIB+ for an updatable data set is
to use two transactions with the data set: a long read-only
transaction (read committed) and a short writing transaction
(concurrency, no wait). The data set has Transaction and
UpdateTransaction properties for that.


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com