November 30, 2007 at 1:56 am
Hi all,
We have a scenario where we want to lock and unlock manually some rows in a table in SQL CE database .First the rows we need should be locked. By using a select query the locked rows will be read and processed in front end. Only if the process is completed in front end, manually I need to unlock rows which I have locked earlier. When rows are in locked state no body should be allowed to access that rows . ( should not allow anybody even to put a select query on that locked rows).
At the same time appending rows in the table should always be allowed.
Is it possible to achieve the above scenario?
Please help me
November 30, 2007 at 4:49 am
ADO does this for you.
Select your data using an ado recordset with the cursor options set to pessimistic locking on a server-side cursor. Make your you do not disconnect or close your recordset while you are processing. Use the Update or UpdateBatch features of ADO to update the data in your recordset.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply