Informix Row Locking 1

[BBanks]

I need to modify our application so that when a user accesses "record #1", that record is locked and any other user is prevented from viewing (selecting) that record until user #1 is done with it.

Can someone please advise me on how to accomodate this? I assume I can do it with locking somehow.

Thanks!

Bob
bbanks@longs.com

 

[cdlvj]

SELECT field1, field2 from yourtable where yourkey = 'key' for update;

using cursors, or

just
begin;
update yourtable
set dummfield = 1
where yourkey = 'key';
<< do your work >>
commit; release lock