Re: sequential numbering

Steve Cosner wrote:
>
> 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
Another option is selecting:
select max(col) + 1
from table;
in the pre-insert trigger.

(Hi, Damon!) Received on Mon Nov 18 1996 - 00:00:00 CET