Selecting sequences into form fields
Date: Wed, 29 Jul 1992 17:23:46 GMT
Message-ID: <1992Jul29.172346.7958_at_deepthought.uucp>
I have 3 sequences: seq_nasrisid, seq_rulingid, seq_licensid. Each of these sequences are displayed in a different block on a different page of the form.
I have a trigger that catches KEY-CREREC which then uses an if statement to determine which block I am in and then fetch the next available sequence into the form for that record.
> if (:SYSTEM.CURSOR_BLOCK = 'MASTER') then
> clear_MASTER_details(TRUE, DO_COMMIT);
> create_record;
> select SEQ_NASRISID.NEXTVAL into :MASTER.NASRISID from dual;
This works fine, however, the if statements do not work for the other two sequences.
> elsif (:SYSTEM.CURSOR_BLOCK = 'RULINGS') then
> create_record;
> select SEQ_RULINGID.NEXTVAL into :RULINGS.RULINGID from dual;
> end if;
Could someone explain what I am doing wrong. Table and sequence permissions are set correctly.
-- Neil Greene ----------- Director, Computer Information Systems ARCI, Inc. 606.254.4060 (P) President, Kentucky NeXT User Group, Inc. 606.254.4864 (F) Email: deepthought!neil_at_ms.uky.edu [NeXTmail]Received on Wed Jul 29 1992 - 19:23:46 CEST