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
_______________________________________________________