Which code should be used?

While updating an existing customer record using the Customers form, the user invoked the Orders form by clicking the CONTROL.Orders_btn button. The When-Button-Pressed trigger had the following code:
CALL_FORM(‘orders’);
There is a requirement to navigate back to the Customers form after the order details have also been updated. This will be achieved through a form-level Key-Exit trigger in the Orders form.
Which code should be used?

While updating an existing customer record using the Customers form, the user invoked the Orders form by clicking the CONTROL.Orders_btn button. The When-Button-Pressed trigger had the following code:
CALL_FORM(‘orders’);
There is a requirement to navigate back to the Customers form after the order details have also been updated. This will be achieved through a form-level Key-Exit trigger in the Orders form.
Which code should be used?

A.
IF GET_APPLICATION_PROPERTY(calling_form) IS NOT NULL THEN EXIT_FORM(ASK_COMMIT, NO_ROLLBACK;
ELSE
EXIT_FORM;
END IF;

B.
VALIDATE(FORM_SCOPE);
IF :SYSTEM.FORM_STATUS <> ‘QUERY’ THEN
GO_FORM(‘CUSTOMERS’);
ELSE
EXIT_FORM;
END IF;

C.
ENTER
IF :SYSTEM.CURSOR_BLOCK = ‘CHANGED’ THEN
COMMIT_FORM ;
ELSE
EXIT_FORM(NO_VALIDATE, NO_ROLLBACK);
END IF;

D.
IF :SYSTEM.FORM_STATUS = ‘CHANGED’ THEN
COMMIT_FORM:
END IF;
GO_FORM(‘CUSTOMERS’);

Explanation:
Oracle Forms Developer 6i: Build Internet Applications II M9-P17



Leave a Reply 0

Your email address will not be published. Required fields are marked *