Re: Need Help With SQL*Forms and Nextval

In article <1993Jul8.211108.29824_at_lmpsbbs.comm.mot.com> maldonad_at_motu370e.comm.mot.com (Ed Maldonado) writes:
>In article <21hfg9$nsv_at_gaia.ucs.orst.edu> mickel_at_OES.ORST.EDU (Paul Mickel) writes:

[some deleted]

>>We had attempted to use sequence numbers in one of our forms to assign run
>>numbers to a production process. The form we were using was a 2-block form.
>>What we found was that the the next run number generate was three more than
>>the last, with the pattern in increment being (#block_on_form+1). We couldn't
>>find a work around and had to abandon the use of sequences.
> You say "assign run numbers to a production process" would the
> second block need this same number or a different (Next number in
> the sequence) Number.

The form is a master detail block, with the run_num getting assigned in the master block. The detail uses the same number the master block. The result we oberserved was that if you had a 2-blk form, moving to a master record in either higher or lower always incremented the sequence number by 3. We observed that for a one-blk form the sequence number was incremented by 2. We were not sure what was going on, but we suspected that something was causing it to increment, possibly navigation to the master record (or another record in the case of a 1-blk form).

-Paul

-- 
Paul M. Mickel			  	   Internet:mickel_at_oes.orst.edu
Database Programmer, Teledyne Wah Chang    Albany, OR   97321
Disclaimer: My employer never claims my opinions (unless it makes a profit).