Phylum Posted August 5, 2003 Posted August 5, 2003 I am writing a concurrency handler for an UNTYPED dataset. I want to present the user with all 3 versions of the record: theirs, current, original . The DBConcurrencyException object makes it easy to retreive "Theirs" and "Original". Getting the current version however presents a problem. How would I re-read the database and get the current version? Quote
*Experts* Nerseus Posted August 5, 2003 *Experts* Posted August 5, 2003 You'll need to re-run the query. That means filling a new DataSet or merging the rows with your existing ones. You'd have to write special queries to get the data you first retrieved via each table's Primary Key (will definitely work), or re-run your original query if you're sure it will return the same rows. Is this for presentation, as in "You've made changes from blah to blah and someone else has updated it to blah behind the scenes"? Sounds robust, but might be tricky. Good luck :) -nerseus Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Phylum Posted August 5, 2003 Author Posted August 5, 2003 Re-running the query is simple. The problem is if it returns more then 1 row your out of luck. I did have a method of finding it, which is loop through all the returned rows until the primary keys are equal. I was hoping for soemthing faster though, 'cause I could be in trouble if 10,000 records or more are returned. I guess if there is no other way i'm out of luck :( Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.