Forms 4.5 Problem (Record Locking)

I have encountered a problem in Oracle Forms 4.5 with regard to record locking.

If I update a record using a Form developed in Forms 4.5, and I move on to another record without choosing the "Save" option (ie. post a commit to the database), then a
[Quoted] [Quoted] default Oracle dialog appears saying ...

"Do you wish to save the changes you have made?"

If I answer "No" to this dialog box, then the record that was changed is not released for other users to update. It is still locked, as if a
"rollback" has not beed executed. The reason I know the record remains
locked is that, when I use the same Form in another session, a "Could not reserve record" dialog appears.

The only way to release the record is to hit the "Save" button (ie. post a commit to the database) or for the user to quit the Form.

Is this a bug?

Surely the record should be released if the answer is "No" to the above dialog box.

Does anyone know a way round this problem.

Any help greatly appreciated.

Pol

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 18 2000 - 10:42:14 CEST