Re: How To Generate Sequence Nbr in Forms 3.0

In article <2qn0m9$ssu_at_gaia.ucs.orst.edu> Paul Mickel, mickel_at_sulaco.OES.ORST.EDU writes:

Ummm....

In article <2qn0m9$ssu_at_gaia.ucs.orst.edu> Paul Mickel, mickel_at_sulaco.OES.ORST.EDU writes:
> One of the things I noticed when I first did this was that the
 sequence
> numbers were incremented each time by a factor of the number of
 blocks on
> the form. If you are not worried about holes in the sequence number,
 this a
> way to go, but if you are, the then pre-insert method may be better.
 I as-
> sume that you are working with SQL*Forms 3.0.

This is kinda tough to do since all that Forms does is select the next value from the sequence# in the database viz:

select :sequence.nextval into <field> from dual;

Sequence numbers aren't 'specially' implemented in Forms. We take advantage of what's in the database.

Kevin Mallory
Manager, Quality and Performance Programs Oracle Forms Development Received on Tue May 10 1994 - 08:52:48 CEST