Re: Skipping fields in SQL*Forms V3

Rodney Coleman (bigbod_at_cerberus.bhpese.oz.au) wrote:

: I am trying to set up a form which has a field in it which
: I want to skip ONLY if the user is entering a new record.
: This field is between other fields in the new record.
 

: I thought I would use a ON-NEW-FIELD-INSTANCE trigger on
: the field with trigger code something like...
 

: if (:system.record_status = 'NEW' or
: :system.record_status = 'INSERT') then
: next_field;
: end if;
 

: The problem is I want the cursor to continue navigating in
: its original direction regardless of whether I enter this
: field from the previous field or the next field.
 

: Is there an easy way to do this ??

I'd use a pre-field trigger on the field in question, and then in the trigger set the attribute of the field based on your record criteria. ex: if (:system.record_status in ('NEW','INSERT')) then

         set_field(:<field_in_question>,enterable,attr_off);
     end if;