On 9/17/07, Ajit Abraham <[EMAIL PROTECTED]> wrote: > > 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. >
I'd suggest that's the _right_ way to do it. You really need to know in the current business application context if the data you are updating is related (in the sense of "update all or update none") to the preceding or following data updates. That state ought to be kept track of in the current object. If you are working in multiple forms and some other form has initiated a transaction that shouldn't affect whether you need to declare, execute and complete a transaction in your current thread of execution. That said, another form shouldn't leave a transaction "hanging out there," but it does happen. -- 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.
