----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: spprivate Message 1 in Discussion Hi folks, Well this has been running for a long time in my mind.Need some clarifications. In a perfect scenario of DB Driven applications,consider the scenarios. *Suppose two users logs in at a same time ,retrieves same record and does some modification,update it (dataset in disconnected mode),obviously,the second to update will overwrite the first one.So there is a conflict,atleast for the first user. *Suppose for a primary key field,I am fetching the max(number)+1,then in concurrent scenario,there is always a possibility that two users get a same number.So when inserting,primary key will throw error and the second user is in panic.. My understanding and a solution for the above scenarios are 1) Either I can have row level locking (pessimistic),but its not feasible in Web 2)Should have a timestamp for records,do some manipulation on that. 3)Capture the database exception and act accordingly. In all cases,my only concern in,can't I give a comfort feeling for the users... So,can anybodt summarize and tell me,what are the key points to be considered when developing a Perfect DB application(if at all one is there :)) in a multiuser environment. Cheers Satheesh ----------------------------------------------------------- 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]
