> Question, if 2 update requests happen at exactly the same time: > > Update table > Set LastUpdateDate=Timestamp, .... > Where KeyId= <whatever the record key is> > AND LastUpdatedate=<value from select> > > What settings would need to be used to ensure that one of the > updates failed.
Well, they won't actually happen at exactly the same time. The database server will run one request, and make the other request wait until the first has finished. Then, it'll run the other request. So, assuming that the first request didn't take so long as to cause the second one to timeout, both updates will run sequentially. Presumably, the first update would change the LastUpdatedate value, so the second one wouldn't find any records to update. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
