Locking and Unlocking rows in SQL CE Table Manually

Question

Locking and Unlocking rows in SQL CE Table Manually

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

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.