|
What is confusing about that help statement? In order to activate Transaction Control you need to 'turn it on' before you issue a 'select' command. This way when the Database gets the 'select' command it will 'remember the transaction so that if you need to 'roll back' you can. (Normally I would use a Roll back feature only in a stored procedure) With the transaction block set to true you can have Envox take control of the transaction.
On this topic I noticed that there seems to be two transactions that take place when Envox executes a Stored Procedure. (Therefore my transactions are doubled and I am forced to use the Envox one if I wanto get to the correct one to roll back. Has anyone seen this type of activity with SQL server?)
Let me know,
Klaz
|