Do you create new generator for same product every year?
If so, why not just reset existing generator?
ALTER SEQUENCE GEN_NR_ID RESTART WITH 0;

--- In firebird-support@yahoogroups.com, Bhavbhuti Nathwani <venussoftop@...> wrote:
>
> Zvjez, this is an app for a pharmacy drugs manufacturing unit. They need
> Batch nos. and Control Nos. for their products and raw materials
> respectively. These nos. are reset every financial year, so for the same
> product I have a generator for each year, thus running into hundreds every
> year.
>
> Thanks and regards
> Bhavbhuti
>
>
> [Non-text portions of this message have been removed]
>