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. ...
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.
When Execute-query or count-query Package procedures are invoked.
Latest Answer : pre-query trigger fires before any execution of a query. this trigger fires only once per query. where as post query fires for each row. ...
No.
Latest Answer : No, we cann't use go_block in pre_field trigger ...
Execute Trigger (trigger-name)
