I'll post the actual code, it's more convoluted than what I said.
________________________________ From: AndyD <[email protected]> To: [email protected] Sent: Tuesday, April 24, 2012 5:08 AM Subject: Re: Re: lockng issues I have found the SQL commands better at handling contention issues, why not: lDate = date() UPDATE YourTableName SET post_date = lDate WHERE post_date <> lDate AndyD 8-)₹ On 23/04/2012 22:57, MB Software Solutions, LLC wrote: > <snip> > > Not sure. My only advice is to change it to this: > > REPLACE post_date WITH date() FOR post_date<> date() ALL in YourTableName > > Also, if that replacement is happening in the Payment table, why would > you want to open it with NOUPDATE? > > hth, > --Mike > > _______________________________________________ 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. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
