Subject [IBO] Re: Connect "Transaction to Connection" or "Connection to Transaction"
Author Marco Menardi
As far as I understand (and I've learned today), Geraldo wanted to
tell you that there is no bi-directional link between the two.
the facts are:
IB_Query needs a connection AND a transaction
IB_tansaction needs a connection
so for every IB_Query you have to specify a Connection + a Transaction
To make things easier, IB_Connection is provided with
DefaultTransaction property, so in IB_Query you can specify only
IB_Connection and leave IB_Transaction property to <default>. That
<default> is the transaction you have choose as DefaultTransaction in
the connection.
So you can have the connection with a default transaction, and specify
<default> in the transaction property of the ib_query, or specify a
particular one at will. If you specify as query transaction the
transaction that you specified as defaulttransaction for the
connection, I think that it will not hurt, but it's a strange setup.
mmmm... did I made more confusion?
hope not ;)
regards
Marco Menardi


--- In IBObjects@y..., Raymond Kennington <progsol@c...> wrote:
> geraldo_ls wrote:
> >
> > --- In IBObjects@y..., Raymond Kennington <progsol@c...> wrote:
> > > What is the difference between connecting components
> > > "Transaction to Connection"
> > > and
> > > "Connection to Transaction"?
> > >
> > > TIA
> > > --
> > > Raymond Kennington
> > > Programming Solutions
> > > W2W Team B
> >
> > There isn't a TIB_Connection to TIB_Transaction connection.
> ...
> >
>
> I just connected
>
> TIB_Connection1.DefaultTransaction as TIB_Transaction1
>
> and
>
> TIB_Transaction1.IB_Connection as TIB_Connection1
>
> so it appears to be possible.
>
> I would like to know what the differences and similarities are.
>
> Now that there is at least one user who is not aware of this, it
seems to be more relevant to understand the differences
> and when to use one or the other.
>
>
> --
> Raymond Kennington
> Programming Solutions
> W2W Team B