Programming Tutorials & Tech
Example is given for Pre-Query and Post-Query triggers in Oracle Forms, with using Display_Item built-in in Post-Query triggers to highlight fields dynamically. This is the screen shot below for this example: You can also download this form from the following link: Query.fmb The example is based on HR schema departments table. In this example Department No. ... Read more
I have written many posts related to triggers in Oracle Forms, I have given examples for Form Level triggers, Data Block Level triggers and Item Level Triggers. And in this tutorial I am just giving the simple tutorial to how to create a trigger in Oracle Form's object navigator. Create Form Level Trigger 1. Click ... Read more
Oracle Forms is having its default records filter, which we can use through Enter Query mode to specify some search criteria or to filter records before display, but you can also create your own filter, which can be more user friendly and easy to use. You can define search criteria in control block and on ... Read more
Example is given below to validate a Text Item in Oracle Forms with specific rules condition which can be define at run time with the use of T-List item and When-Validate-Item trigger. Below is the screen shot of this example form which can be download free from Google Drive with the following link: Validate.fmb The following ... Read more
Suppose you want to give an option to user to select only 5 check boxes from given any number of check boxes in an Oracle Form and if user selects more than 5 than give a message that you can not select more than 5. For this follow these steps: Create 10 check boxes in ... Read more
Suppose you want to check the user permissions on inserting or updating the records in Oracle Forms, then you can use Pre-Insert and Pre-Update triggers for that particular data block to check whether user is having proper permission or not. The example is given for HR schema and the following demo table is created for ... Read more
Sequence of triggers fires on Commit. 1. KEY Commit 2. Pre Commit 3. Pre/On/Post Delete 4. Pre/On/Post Update 5. Pre/On/Post Insert 6. On commit 7. Post Database Commit Sequence of triggers fires when Form is opened and closed. On Open 1. Pre-Logon 2. On-Logon 3. Post-Logon 4. Pre-Form 5. When-Create-Record 6. Pre-Block 7. Pre-Record 8. ... Read more
Whenever we commit after entering data in Oracle Forms, many triggers fires during this event and also Pre-Update and Pre-Insert triggers fires just before inserting or updating the record into table. We can write Pre-Update and Pre-Insert triggers on particular block to just allow the process or to stop the process by using "Raise Form_Trigger_Failure" ... Read more
A user-named trigger is a trigger defined in a form by the developer. User-Named triggers do not automatically fire in response to a Form Builder event, and must be called explicitly from other triggers or user-named subprograms. Each user-named trigger defined at the same definition level must have a unique name.To execute a user-named trigger, ... Read more
I wrote this trigger around 4 years ago to handle errors in an application based on Oracle Forms 6i. This trigger handles all errors with some custom messages for some specific errors and not only this after giving an appropriate message to the user it logs the error into a table named error_log so that ... Read more