Welcome to envoxforums.co.uk Sign in | Join | Faq

Envox 6.x

Started by akennedy at 06-27-2007 5:58 PM. Topic has 2 replies.

Print Search
Sort Posts:    
   06-27-2007, 5:58 PM
akennedy is not online. Last active: 10/5/2007 6:50:29 PM akennedy

Top 10 Posts
Joined on 05-29-2007
Posts 6
DBTransBegin Block
Reply Quote
Does anyone have any expirence using transactions with a MySQL database (innodb tables)?

The help mentions:

To activate transaction control successfully after establishing a connection with the database (DBOpen block), it is necessary to execute the DBTransBegin block, before any DBSelect or any other block from this group is used.

I find this confusion.  Anyone with expirence with tips or pointers?

   Report 
   07-02-2007, 11:20 PM
klazno4 is not online. Last active: 1/14/2008 3:14:34 PM klazno4

Top 10 Posts
Joined on 06-12-2007
Posts 4
Re: DBTransBegin Block
Reply Quote

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


   Report 
   07-06-2007, 6:14 PM
akennedy is not online. Last active: 10/5/2007 6:50:29 PM akennedy

Top 10 Posts
Joined on 05-29-2007
Posts 6
Re: DBTransBegin Block
Reply Quote
I guess I read the help statement as being <<You have to execute the DBTransBegin immediately following the DBOpen block>>

Thanks for the clearification!

   Report 
envoxforums.co.... » Version Specifi... » Envox 6.x » Re: DBTransBegin Block

Powered by Community Server, by Telligent Systems