Re: Sequence in SQL*FORM (help required)

From: Kim Ng <kimmng_at_pebbles.uswnvg.com>
Date: 8 Nov 1994 19:27:47 GMT
Message-ID: <39ojfj$lb_at_fred.uswnvg.com>

(1) Don't use "default value". As you have seen, it wasted the sequence!
(2) Use "pre-insert" to get the next sequence for a new record. This way

    you can do anything you want before or after generating the sequence     (select seqgenerator.nextval into :fieldname from dual).
(3) If you don't want to waste sequence number, don't use the cache/buffer

    for the sequence when you create it. (read the manual for details)

Have fun.

---

 Kim Ng
 (Whatever I say and own are mine, mine and only mine! So, don't you dare   claim they are yours!) Received on Tue Nov 08 1994 - 20:27:47 CET