Hi Tim. Yes, I tried sending SELECT FOR UPDATE in an ADO command or by executing a procedure containing SELECT FOR UPDATE, and it works, but only while the command or procedure is executing. I am trying to find a way to lock a record from ADO, do some processing (with and without other ADO commands) then unlock the record when I am done.

>Did you try:
>
>select columns from table_name for update