Skipping fields in SQL*Forms V3
From: Rodney Coleman <bigbod_at_cerberus.bhpese.oz.au>
Date: Wed, 22 Sep 1993 05:15:48 GMT
Message-ID: <1993Sep22.051548.29340_at_cerberus.bhpese.oz.au>
Date: Wed, 22 Sep 1993 05:15:48 GMT
Message-ID: <1993Sep22.051548.29340_at_cerberus.bhpese.oz.au>
Forgive me if this seems a trivial question, but I do not have any people at our site with SQL*Forms experience. 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 ?? Thanks in advance for any assistance !! (BTW, e-mail would be prefered as I dont get a chance to read this group regularly...) -- Everytime I open the door, | Rodney Coleman, Analyst Programmer its the same DAMN thing...... | BHP Information Technology That bitch bends over, | Newcastle, Australia.and I forget my name !! (Gene Simmons) | (bigbod_at_liberator.bhpese.oz.au) Received on Wed Sep 22 1993 - 07:15:48 CEST