Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Trigger - Validation on Exit

Trigger - Validation on Exit

From: Ian Dunn <ian_at_idunn.demon.co.uk>
Date: 1997/06/18
Message-ID: <zkI2xFAkzEqzEwAG@idunn.demon.co.uk>#1/1

Hello ORACLE people
I am using Forms 3 and Oracle 6 and I could do with some advice about trigger usage for validation and navigation. Basically, I have a small procedure, for example

                                proc aa is
                                        begin
                                        if x is not null then
                                           if y is not null then
                                                go_field(‘x’);
                                           else
                                                message(‘error’);
                                           end if;
                                        end if;
                                        end;

Ideally I would like it to go in the ON-VALIDATE-FIELD trigger, but I can’t due to the go_field, so I have put it in the KEY-NXTFLD trigger. Most of my other field validations use this trigger and when I do EXIT or COMMIT, if there is anything wrong then I am informed and then prompted with if I want to quit or not, which is what I want to happen. (By the way on the KEY-EXIT trigger I have exit_form and on the KEYCOMMIT  trigger I have commit_form followed by exit_form.)

BUT..ideally I want this procedure to work in the same manner. So I have put proc aa in the KEY-EXIT and KEY-COMMIT triggers, which works OK but I don’t get the option to quit if an error occurs. Do I have to live with this!!

Thanks in advance.

-- 
Amanda Pickard
Received on Wed Jun 18 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US