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
>all
> > your TIB_DSQLs (i.e. are you sure you commit the right
>transactions)?
>
>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
IBODatabase.

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.

Helen

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