Hi Dave, I am surely missing something very obvious.
I googled for "active transaction mysql","open transactions mysql" etc, searched the mysql help, scanned thru Whil's VFP-Mysql book, but could not find the magic word. I am currently studying Andy Kramek's data class and trying to create a MySql connection and behaviour object. All I need to do, is in the data class - issue a START TRANSACTION if a transaction does not exist for the current connection to MySql. So my question - how to find out if a transaction is in progress in MySql. For the time being, I am maintaining a counter, as Andy has shown in his VFP connection object. Sincerely, _Ajit Abraham Dave Crozier wrote: > Ajit, > Scratch that. I automatically went into PHP mode then. > > .... > Is there any way to find the number of active transactions for a > connection to MySql? (similar to @@TRANCOUNT in MS-SQL) > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
