--- In IBObjects@yahoogroups.com, "Steve Sinclair" wrote:

> procedure Tdm.qryAfterSearch(IB_Dataset: TIB_Dataset);
> begin
> // This makes it so that the user will not keep a transaction open
> all day.
> // This is VERY VERY important!
> if trn.Started then
> trn.Commit;
> end;
>
> I figured I could ...
> 1) Just use autocommit

A simple solution, but it does imply that the server cannot do it's
housekeeping and the oldest active transaction will not advance until
you do a proper commit. Hence, this solution may lead to problems with
performance and that the database gets bigger than neccessary (it
needs to keep copies of all changes to the database since the last
real commit). Though, of course, this isn't always important. E.g. I'd
be very surprised if any such problems arose when using the embedded
version.

Set