sql *forms is 4gl tool for developing and executing; Oracle based interactive application.
on-validate-field trigger fires, when the field validation status new or changed.Post-field-trigger whenever the control leaving form the field, it will fire.
post-field trigger fires whenever the control leaving from the filed.Post-change trigger fires at the time of execute-query procedure invoked or filed validation status changed.
a. On-insert b. Post-insert c. Pre-insert pre-insert,on-insert & post-insert.
execute trigger (trigger-name)
it will fires whenever SQL * forms would normally attempt to lock a row.
key-startup trigger fires after successful navigation into a form. pre-form trigger fires before enter into the form.
key-startup trigger fires after successful navigation into a form.Pre-form trigger fires before enter into the form. package procedure & function
a package procedure is built in PL/SQL procedure.
1. Restricted package procedure. 2. Unrestricted package procedure.
Restricted package procedure that affects the basic functions of SQL * forms. It cannot used in all triggers except key triggers. unrestricted package procedure that does not interfere with the basic functions of SQL * forms it can be used in any triggers.
it synchronizes the terminal screen with the internal state of the form.
anchor-view resize -view move-view.