Ajit, I can honestly say I haven't really had to do what you are doing. I don’t know whether this small article may help but take a look at:
http://www.weberdev.com/ViewArticle/456 They use the @@tx_isolation variable which can be set accordingly and retrieved. It doesn’t really answer the full question but it shows a way of setting the buffering method. I'm Googling away to see if this variable can be used in conjunction with anything else which will retrieve the actual number of updates though. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajit Abraham Sent: 17 September 2007 16:17 To: [email protected] Subject: Re: TRANCOUNT 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) > [excessive quoting removed by server] _______________________________________________ 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.
