The default locking in SQL*Forms 3.0 (if you make an query with FOR_UPDATE
option), the record is locked, when you change its value. When the record is
already locked, you get the message :
Attempt to preserve record for update or delete. Press CONTROL-C to cancel...
Is it possible to avoid this message and then giving the user a message without
waiting for the CTRL-C. In my own programs I can make a Lock with NOWAIT option
and then I get an error, if the lock is used by another process, but a simple Select in Forms does never make any locks, even if I made an explicit lock
statement.
The other way is never to lock anything and always get the message :
Record updated by another user, plese requery.
Is there any use of the ON-LOCK-Trigger?
Is it possible to make an explicit lock (e.g. row exclusive) at the time of
the query ?
How can I lock other tables which contains references on the current visible
data and must be updated/deleted with the current record ?
If you have solved this problems please mail me your solution to :
