This content has been marked as final. Show 2 replies
By default, a record in forms gets locked when you start editing the record (means, start typing in a field of the record).1 person found this helpful
If you see the record is already locked after the query, this is typically caused by code in the POST-QUERY-trigger of the block. If you have field-assignments in the POST-QUERY, you have to make you that there is no "cross-validation" which changes a database-field in the record and with that causes a lock for that record. So check the POST1AUERY -trigger in your form. a solution for this is to mark the record as QUERY at the end of the POSt-QUERY using SET_RECORD_PROPERTY.
Another option would be to change the Locking Mode property of your data block(s) to Delayed. This will cause Oracle Forms to only lock the record when a Commit is issued rather than when an edit (which is the default) occurs.1 person found this helpful