![]() ![]() 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 |