Subject Re: [IBO] TIB_TransactionState
Author H.Klomann
Hi Rolf,

> is it right, a transaction can be in status tsInactive and
> is physically NOT started?

As far as I see, the answer is NO.
But when the transaction was physically startet and after endet,
then status can be tsInactive.
See the nice example in IBO4\Tutorials\TransactionOAT to verify this.


> SELECT R.RDB$FIELD_NAME
> , R.RDB$RELATION_NAME
> FROM RDB$RELATION_FIELDS R, RDB$FIELDS F
> .....
>
> This only happens, when IB_Controls are assiggned to the Dataset?

Yes, when IBO needs to query metadata to reflect dataset details for
display reason. If you set the SchemaCache to an valid directory, this
happens only once. Without having SchemaCache set, this happens always
after opening the dataset - when any controls assigned.

> Should i be free of care for thie internal transactions? (Tuning OAT's)
IMHO you should.


Hope that helps,
Harald Klomann


Rolf Bredemeier schrieb:
>
> Hi list,
>
> is it right, a transaction can be in status tsInactive and
> is physically NOT started?
>
> I struggle with this behaviour, because in the IBO helfile i found the line:
> "tsInactive - Transaction has been started but no DML or DDL has been executed causing it to become active."
>
> A physically transaction is only started when TIB_Transaction.started=TRUE, right? Independent of
> the TIB_TransactionState?
>
> Next question:
>
> I have a TIB_Query, assigned a transaction and connection.
> The SQL is [select id, bez1 from tsmwar00 where artnr starting with "107-"]
> In the IB_MonitorDialog i can see, that a statement is automatic generated with
> SQL like following
>
> SELECT R.RDB$FIELD_NAME
> , R.RDB$RELATION_NAME
> FROM RDB$RELATION_FIELDS R, RDB$FIELDS F
> .....
>
> This only happens, when IB_Controls are assiggned to the Dataset?
>
> The above statement has is own internal transaction? And how to commit,
> physically end this transaction? It seems, the transaction ends automatic
> after a minute or so. Independet from TIB_TimeoutProps of my transaction?
> Should i be free of care for thie internal transactions? (Tuning OAT's)
>
> Please, don't spend long time for answering my questions, just a few
> keywords for searching the help or an url is enough, i think. And hope! ;-)
>
> Best regards, Rolf
>
>
> ___________________________________________________________________________
> 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 !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/