----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <ib-support@yahoogroups.com>
Sent: Saturday, August 18, 2001 1:48 PM
Subject: Re: [ib-support] Sequential running no using trigger and generator


> At 01:45 PM 18-08-01 +0800, you wrote:
> >Thanks Ivan,
> >
> >Emm.... my scenario here is that I assign sequential running no to a
> >document issued by users upon posting. So users won't get to know their
> >respective doc no until they post it, this is to avoid "wastage" of
> >generated doc no and also try to minimize "voids". But I am afraid that
> >sometimes users won't be able to commit to their transaction due to
certain
> >errors (which is unlikely), so, I think it would be good to have a
continuos
> >number in the db when users try to query the result, since my approach
> >somehow hints that they will get "continous numbers"
>
> Junior,
>
> Take a look at this if you don't have it already:
> http://www.ibobjects.com/docs/ti_AuditableSeries.zip
>
> -- Helen
>
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>