Subject | Transaction Oddities |
---|---|
Author | Campbell Fuller |
Post date | 2002-08-23T07:25:41Z |
Ok, so I have an IB_Connection and an IB_Transaction. The Transaction links
to the Connection component via the IB_Connection property.
Ques. 1 - Do I need to link the DefaultTransaction property of the
IB_Connection to the IB_Transaction component?
The IB_Transaction is configured as follows: -
AutoCommit True
Isolation tiCommitted
LockWait False
RecVersion True
ServerAutoCommit False
For general inserts and updates I am not issuing StartTransaction or Commit
statements - I'm assuming that this happens automatically.
However, There are times when I'm doing a batch type input or update where I
want control the transaction myself so that I can RollBack if necessary. I
am doing one such update where I import a a Header Record and all its detail
records - the process is bound by a StartTransaction - Committ (with a
rollback on failure).
Ques. 2 - Why is it that upon issuing the COMMIT my datasets are closed???
Rather odd behaviour but thats what happens!
Ideas anyone?
Thanks
Campbell
to the Connection component via the IB_Connection property.
Ques. 1 - Do I need to link the DefaultTransaction property of the
IB_Connection to the IB_Transaction component?
The IB_Transaction is configured as follows: -
AutoCommit True
Isolation tiCommitted
LockWait False
RecVersion True
ServerAutoCommit False
For general inserts and updates I am not issuing StartTransaction or Commit
statements - I'm assuming that this happens automatically.
However, There are times when I'm doing a batch type input or update where I
want control the transaction myself so that I can RollBack if necessary. I
am doing one such update where I import a a Header Record and all its detail
records - the process is bound by a StartTransaction - Committ (with a
rollback on failure).
Ques. 2 - Why is it that upon issuing the COMMIT my datasets are closed???
Rather odd behaviour but thats what happens!
Ideas anyone?
Thanks
Campbell