Hi No so Allen, I have some code in a BeforeSave method, where I do some cleaning and before that, data is changed in a grid. I have a Save method that calls the BeforeSave and then start the Begin Transaction which calls the BizSave method and so on.
What happened was that I had two instances of VFP 7.1 opened across a network accessing the same tables. But why would it work inside the Begin Transaction ? E. -----Original Message----- Something odd just happened... REPLACE Something WITH Newthing IN SomeTable ---- BEGIN TRANSACTION --- lSave = TABLEUPDATE(0,.T.,[SomeTable]) ---- ---- It will fail, saying that a lock could not be placed, but only sometimes. If I put the REPLACE inside the TRANSACTION it works ok. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.17.5/1190 - Release Date: 19-Dec-07 19:37 _______________________________________________ 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.
