|Subject||Re: [IBO] TIB_TransactionState|
> is it right, a transaction can be in status tsInactive andIt would be tsNone if it is not started.
> is physically NOT started?
tsInactive means there is a transaction handle present, there just hasn't
been any updates.
> I struggle with this behaviour, because in the IBO helfile i found theline:
> "tsInactive - Transaction has been started but no DML or DDL has beenexecuted causing it to become active."
Yes, that is perfectly descriptive.
> A physically transaction is only started whenTIB_Transaction.started=TRUE, right? Independent of
> the TIB_TransactionState?Yes.
> Next question:"107-"]
> I have a TIB_Query, assigned a transaction and connection.
> The SQL is [select id, bez1 from tsmwar00 where artnr starting with
> In the IB_MonitorDialog i can see, that a statement is automatic generatedwith
> SQL like followingIf you are using a GUI then IBO will take care of these issues for you
> 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)
automatically. I think the time you would have to be concerned is if you are
using your own explicit sessions. You just have to make sure the session is
doing the "passive task" processing. This is what all the transaction OAT
stuff is hooked into.
CPS - Mesa AZ