----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Neeraj_Bangalore Message 4 in Discussion One of the ways could be use the uniqueIdentifier, Identity or timestamp field in the corresponding table, which should be modified when the corresponding row is modified. Just before update see whether the value in that field is same to you fetched earlier or not. If yes, then go ahead with update and if No , then the record has been updated by somebody else - Throw Error. Regards, Neeraj Saluja SCT Software Solutions, Bangalore -----Original Message----- From: spprivate [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 12:36 PM To: BDOTNET Subject: Re: How to Control Concurrency problems like LostUpdates or Dirtyreads thru program New Message on BDOTNET How to Control Concurrency problems like LostUpdates or Dirtyreads thru program Reply Reply to Sender Recommend Message 3 in Discussion From: spprivate Hi, but dont it increase the number of transactions.What if i will be having single insert statements where in I update some master tables etc.. Cheers Satheesh View other groups in this category. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
