Interested to Buy Any Domain ? << Click Here >> for more details...
how to create the triggers in the forms?
- 3 Answers
- 8279 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kavitha
we create triggers at three level
form level,
datablock level,
item level.
so we create triggers for any scope to perform specified
action when we validate the values within the application.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ddpras
They are 4 Levels of triggers
Form Level
Block level
Record Level
Item Level
This is the prority of triggers.firing order like this Form
level,Block level,Record level then Item Level
If you want to validate the values of an Item, usually use
Item level trigger, such as POST-Test,Pre-Test,when-new-Item
trigger.
In Form Level triggers are When-new-form,pre-form,Post-form,
In Block level triggers are when-new-block,pre-block,post-block,
In Record Level triggers are when-new-record,pre-record and
Post-record
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / wyfwong
There are three types of triggers:
Form level
Block level
Item level
If you want to validate the values of an Item, usually use
Item level trigger, such as POST-CHANGE trigger.
| Is This Answer Correct ? | 6 Yes | 2 No |
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
explain about content canvas views?
Use the add_group_column function to add a column to record group that was created at a design time?
how do u compile a form i.e .fmb file in Unix or in dos
Why oracle forms required?
how do u call a report from form
What do you understand by lov and how can it be used?
EXIT_FORM is a restricted package procedure ?
How do you control the constraints in forms ?
Can a sigle canvas be used by different blocks ?
What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?
can i write commit in Before report trigger
Oracle General 
