Oracle Forms

Group,

I have a form that has a multi row view. To be able to edit a given row, the user wants to have the edit in a dialog window. So to ensure data concurency, I want to lock the record before going to the edit window. But the user has an option of canceling the edit. So I need to be able to unlock the record. How do I unlock that given record?

So far my only solution seems to be issuing a forms_ddl('rollback'); followed by a requery of the block. Not very elegant. The rollback gets rid of the lock in the DB, but for some reason the forms record manager still thinks there is a lock because it won't issue another select for update untill the block has been requeried.

thanks.

--pat