Flagged as NF, since I don't see FoxPro in your question... On 9/17/07, Ajit Abraham <[EMAIL PROTECTED]> wrote: > > Is there any way to find the number of active transactions for a > connection to MySql? (similar to @@TRANCOUNT in MS-SQL) >
It's certainly not as easy, as SQL Server is a monolithic application, and MySQL is a front-end that may go through a middle tier to a number of different storage engines, some of which don't support transactions. I'm curious; why is it you want to know this? Which interface are you using? Which storage engine (s)? FoxPro's TXNLevel only works for VFP-DBF-based transactions, doesn't it? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ 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.

