home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases.oracle
- Path: sparky!uunet!wupost!ukma!deepthought!neil
- From: Neil Greene <deepthought!neil@ms.uky.edu>
- Subject: Selecting sequences into form fields
- Message-ID: <1992Jul29.172346.7958@deepthought.uucp>
- Sender: neil@deepthought.uucp (Neil Greene)
- Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
- Organization: ARCI, Inc.
- Date: Wed, 29 Jul 1992 17:23:46 GMT
- Lines: 27
-
- 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@ms.uky.edu [NeXTmail]
-