Kernel Error (0x70505) Record Lock

[Ivan Smahin]

On 2/26/2011 8:22 PM, Warren Kuhl wrote:
> Ivan,
>
> Thanks for the info on record locks.  I will do my selects with out 
> record locks.  But now my problem is...if I have a record that is 
> locked.  How can I unlock it?
>
>

The only reason to have a locked record is another cursor which locked 
that record.
It will be locked until that cursor die.

The nature of the locks are not permanent- I mean close/open database 
(locally - not under vServer) will remove all the locks.
But if the record is locked then some cursor locks it and you should 
control cursor life cycle to avoid it.


-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com