![]() ![]() The “ WHEN-NEW-FORM-INSTANCE ” trigger will be used to prepare objects or an action when entering to a new form. Some other useful triggers are: PRE-INSERT and WHEN-NEW-FORM-INSTANCE.Ī PRE-INSERT trigger fires once before each new record is inserted in a commit process. Your Post-Query trigger can contain code to calculate or populate control items. So, you can use it to enhance a query’s records in a number of ways. It fires after records are retrieved but before they are displayed. ![]() The POST-QUERY trigger fires before selected records are presented to the user. The PRE-QUERY trigger fires before the select statement is finalized. The most popular of them are the PRE-QUERY and POST-QUERY. You can attach several triggers to a data query. ![]() Or, we can say, a forms trigger is a set of PL/SQL actions that happen each time an event such as when-checkbox-changed, when-button-pressed, or when-new-record-instance occurs. Each trigger’s name defines what event will fire it for instance, a WHEN-BUTTON-PRESSED trigger executes its code each time you click on the button to which the trigger is attached. When a trigger is fired, it executes the code it contains. Triggers are attached to objects in your application. A Global Variable is a binding variable that can be used by multiple Form Modules.Ī forms trigger is a block of PL/SQL code that adds functionality to your application. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |