Oracle Forms

Hi,

Its general question, not a duplicate for my previous post..


PRE-FORM VS PRE-QUERY :

when will exactly pre-form will fire ? In a scnario where user enter one field as input, based on this child block on same form will gets its data.. whether in this scenario IS PRE FORM IS WORKABLE SOLUTION ?.. can we do where clause manipulations here..

PreQuery:

doing where cluase manipulation here. and LOOP through... i heard thaT loop in pre-query not permitted and we cant use next record kind of stuff.


PRE-FORM VS WHEN NEW FORM INSTANCE which is best place to put code for dynmically overiding form default execute query based on values from some queryable field on form...

Thanks
Prasanth