i am select one record from one table by opening a recordset using ADO (C++) as
while this recordset is open, i want to restrict (should not allow read access also) other application to access this record (literally this record should become un-visible) untill i update that record, commit the transaction and close that recordset.
for this i am using ADO's "adLockPessimistic" as lock type while opening the recordset. but what i found is that, while my recordset is open, this record is still visible to other apps and they are able to read the values from this record...
can anyone have ideas...
(i have asked a related question about record level locking in Oracle section also)