On Mon, Mar 10, 2008 at 9:46 AM, Charlie Coleman <[EMAIL PROTECTED]> wrote:
> > At 03:04 PM 3/10/2008 +1300, Sytze de Boer wrote: > >Hi Folk > > > >Scenario: > >ONE user is editing a stock record in a form, and goes to lunch > >ANOTHER user is doing something else and his module issues a command like > >REPLACE ALL something > >It hits the 1st user stock item who has a record lock on the item that's > >being edited > > There are 2 schools of thought on this aspect: sort of the like: > > 1) first guy to start work on the record gets precedence > 2) first guy to finish work on the record gets precedence (or > --------------------------------------------------------------------------------------------------------- I use a builder to create the update clause that is all param passed. Update my table set <my changed column list = @newVar> where key = ThatKey and AllOtherColmuns = All_InitialValues Our entity framework does this on it's own. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- 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.
