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 ...
1. Navigational Triggers. 2. Transaction Triggers.
Latest Answer : pre triggers,post triggers,when trigger,transactional trigger,validation triggers,key triggerskishor ...
Function Key Key-function Key-others Key-startup
Latest Answer : 1. Interface Triggers2. Navigational Triggers ...
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,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD.KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD.
Latest Answer : ON-VALIDATE-FIELD -> KEY-NEXTFLD -> POST-FIELD -> POST-CHANGE ...
These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default
Latest Answer : hi Triggers are like stored pocedure consisting of batch of sql statements. ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS attached to the respective tables get fired when the tables gets manipulated by the query containing DML statements and checks for ...
