Updatng via ADO.NET
From: Halbert09 <junk01_at_optonline.net>
Date: 17 May 2002 14:31:05 -0700
Message-ID: <338ccebe.0205171331.4f2cf6d6_at_posting.google.com>
Date: 17 May 2002 14:31:05 -0700
Message-ID: <338ccebe.0205171331.4f2cf6d6_at_posting.google.com>
We have a VB .net windows form updating oracle tables using OleDbDataAdapter, disconnected data set, and parameters passed as an array list to an Oracle stored procedure. The queries and updates are working. What is the best way to assure that with several concurrent users User#1 is not allowed to overwrite with "old" data a row that has already been updated by User#2, where User#2 acquired and updated the row subsequent to User#1 querying (but not yet updating) that row.
Thank you. Harold Received on Fri May 17 2002 - 23:31:05 CEST