Re: Locking question

From: Ingo Zawada <IZawada_at_de.oracle.com>
Date: Mon, 19 Oct 1998 17:40:50 +0100
Message-ID: <362B6B92.28CAE6E7_at_de.oracle.com>


Hi Michael,

the answer is that form generate the following

select

        'something'
from X
for update of ...

where 		rowid    = :block.rowid 
	and	column_1 = :block.column_1
	and	column_2 = :block.column_2
	and	...
	and 	column_n = :block.column_n 

If Forms can not lock the row someone else has modified the record and you have to requery the record.

MfG Ingo Received on Mon Oct 19 1998 - 18:40:50 CEST

Original text of this message