Selecting sequences into form fields

From: Neil Greene <deepthought!neil_at_ms.uky.edu>
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

Original text of this message