I plan to retrieve a record using &#039adlockpessimistic&#039 so that other users will not be able to access it. But I am unsure as to the method/property to use when checking whether or not the record is locked. If a record is locked, I want the user to move to the next free record. I believe &#039state&#039/&#039status&#039 properties may be the solution, but am unsure as to how to implement them to check a record.