Dear All,
This is from Japan FM team.
My cusotmer is using call_form to open another form.
Because using builtin "LOCK_RECORD" in trigger "ON-LOCK" of DataBlock in the second Form,
when changing a field the record is locked.After changed a field and click menu Action->Exit,dialog is shown.
If click "No",according to the following Sql to judge that the record is not unlocked
select object_id from v$locked_object;
If click "Yes",according to the above Sql to judge that the record is unlocked
***But once Clicked "Yes',even though change this field again and click "No" of dialog,the record is still unlocked.
I think that action of "yes' is commit,and action of "No" is rollback.
Reproduciblity:
Forms Version OS DB Version
------------- -------- -----------
Forms11.1.2.1.0 Windows 2008 R2(64) 11.2.0.1
Forms11.1.2.2.0 Windows 2007 (64) 11.2.0.4
Forms12.2.1.200 Windows 2007 (64) 11.2.0.4
Could you give me some advice?or Is this a bug?
Regards,
David.