Subject Re: [IBO] Re: Memory use and TIB_DSQL
Author Helen Borrie
At 09:33 AM 8/03/2004 +0000, you wrote:

> > No good idea, I'm afraid, just a potentially annoying question:
> >
> > Have you checked the IB_Transaction and IB_Connection property of
> > your TIB_DSQLs (i.e. are you sure you commit the right
>Yes I have, But I'll double check them.
>Just to be sure......

Actually, Michael, Svein's question is very astute. If you have an
IB_Transaction (or an IBOTransaction, for that matter) then you have
(potentially) two transactions. One is that one, the other is the
<Default> transaction to which your statement will be assigned if you
forget to select the one you added.

Dropping a transaction object onto your datamodule doesn't make it the
default transaction. You can, however, make it so, by picking that
transaction as the DefaultTransaction property of your IB_Connection or

I consider it is good practice to *always* put down your own transaction
object(s) and never to make any assumptions about the <Default> transaction
By that, I am not saying there is anything *wrong* about <Default>
transaction, just that it is sometimes easy to overlook the obvious if you
don't pay explicit attention to it.


>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links