SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.
Select the use constraint property is ON Block definition screen. BLOCK
Latest Answer : We control the constraints in forms while selecting primary key 'yes' in property palett. ...
A piece of logic that is executed at or triggered by a SQL *forms event.
Latest Answer : A forms trigger is a block of PL/SQL code that adds functionality to your
application. Triggers are attached to objects in your application. When a
trigger is fired, it executes the code it contains. Each trigger’s name defines
what event will ...
Function key triggers are associated with individual SQL*FORMS function keysYou can attach Key function triggers to 10 keys or key sequences
Latest Answer : Function Key Triggers - are associated with individual Runform function keys. A function key trigger fires only when user presses the associated function key. The action defined in Function Key Trigger replaces the default action of function key. For ...
It fires just before SQL * forms the current block.
Latest Answer : that master detail trigger name is on-clear-details. so this trigger does not exist atleast in 6 and above versions. don'y know abt lower versions ...
using On-Message or On-Error triggers.
Latest Answer : other then on-error trigger , you can use exception also in that blockwith the help of a small procedure and alert you can populate the message and with raise_form_trigger_failure transaction can be controlled. ...
Execute Trigger (trigger-name)
It will fires whenever SQL * Forms would normally attempt to lock a row.
What is the difference between restricted and 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
Host (E.g. Host (sqlplus))