Subject Re: Transactions
Author Stephen Boyd
I've seen this happen in my code and the usual culprit is a query that
returns a lot of rows. If you have that query set to 'fetch all on
commit' then all those records get read before the commit takes
places. This doesn't happen when using BDE and auto commit. Are you
sure that you haven't inadvertently structured a query is such a way
that the result set is large even though you only want the first record