Subject Re: [ib-support] Sequential running no using trigger and generator
Author Helen Borrie
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"


Take a look at this if you don't have it already:

-- Helen

All for Open and Open for All
InterBase Developer Initiative ยท