Re: sequential numbering
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1996/11/12
Message-ID: <56a81u$hpr_at_shadow.CSUFresno.EDU>#1/1
Date: 1996/11/12
Message-ID: <56a81u$hpr_at_shadow.CSUFresno.EDU>#1/1
In article <32838676.2929_at_ix.netcom.com>,
Damon Bowman <dbowman2_at_ix.netcom.com> wrote:
>does anyone know of a way to sequentially number records in a
>multi-record block? Business requirements preclude the use of sequences
>due to the possibility of dropped numbers.
Use a post-query trigger or loop through the block after it has been queried. Use a parameter or an item in a control block to hold the number you are incrementing. Add one to the parameter/control value and place the result in the sequential number item in the block.
Steve Cosner Received on Tue Nov 12 1996 - 00:00:00 CET