|Subject||Re: Hundreds of Generators|
Yes Zvjez, but what happens if the user goes to last year just completed and does retrospective data-entry the counter will all go wrong and retro data-entry is a high possibility of happening.
--- In email@example.com, "zvjezdantomicevic" <zvjezdantomicevic@...> wrote:
> 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 firstname.lastname@example.org, 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]