Re: Row level locking: how to do it?
From: Lim Tik Meng <mte_at_moe.ac.sg>
Date: 1996/08/05
Message-ID: <4u3img$8js_at_socrates.moe.ac.sg>#1/1
Date: 1996/08/05
Message-ID: <4u3img$8js_at_socrates.moe.ac.sg>#1/1
Many thanks for those who gave advice. Base on their advice I have been able to find a solution to my problem in enbedding SQL in Forms scripts. The following illustrates:
User A:
select teacher_name from teachers where teacher_id='MTE' for update nowait;
update teachers set teacher_name='PETER' where teacher_id='MTE';
--> successful
User B:
select teacher_name from teachers where teacher_id='MTE' for update nowait;
--> returns resource busy
select teacher_name from teachers where teacher_id='CBF' for update nowait;
update teachers set teacher_name='Boon For' where teacher_id='CBF';
--> successful
regards,
Peter Received on Mon Aug 05 1996 - 00:00:00 CEST