Answer Posted / Bipin Bihari Chauhan

1. Before Master Form Trigger: Fires before the master form is loaded.
2. After Master Form Trigger: Fires after the master form has been loaded but before any detail form manipulations.
3. Before Detail Form Trigger: Fires before a new detail record is displayed or edited.
4. After Detail Form Trigger: Fires after a new detail record has been displayed or edited.
5. On Delete Trigger: Fires when a master record is deleted and all related detail records are to be deleted.
6. On Insert Trigger: Fires when a new master record is inserted and the related detail records need to be created.

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

2227