Subject Re: Hundreds of Generators
Author zvjezdantomicevic
Sure.
But with some unique constraints and transaction control it might be done.
Also, generators can present a problem if numbers must be consequent.
Best of luck

--- In firebird-support@yahoogroups.com, Milan TomeĀš - Position <tomes@...> wrote:
>
> That's not a good solution because of possible duplicity. Generators are
> not under the transaction control, but triggers (in fact data modified
> by triggers) are.
>
> Milan
>
> Dne 29.04.2010 10:37, zvjezdantomicevic napsal(a):
> >
> > Just from top of my head:
> > How about creating table
> > ITEM_ID int
> > YEAR int
> > COUNTER int
> > and use triggers.
> > If record for that year does not exist,insert it with counter 0,
> > and if it does, increase counter by 1 using trigger.
> >
> > You have if exists, insert or update statements, and before
> > insert/update triggers at your disposal to do this.
> >
> > --- In firebird-support@yahoogroups.com
> > <mailto:firebird-support%40yahoogroups.com>, "venussoftop"
> > <venussoftop@> wrote:
> > >
> > > It think it is necessary, from my POV, please correct me if I am
> > thinking wrong. The numbers are for batch no. of pharmacy products and
> > numbering is restarted every financial year and because they are used
> > on consumer readable labels I need them as integers. The generated
> > numbers look like this finally ITM001-505-09/10 where ITM001 is the
> > product code, 505 the generator number and 09/10 the financial year.
> > >
> > > Thanks and regards
> > > Bhavbhuti
> > >
> > > --- In firebird-support@yahoogroups.com
> > <mailto:firebird-support%40yahoogroups.com>, "zvjezdantomicevic"
> > <zvjezdantomicevic@> wrote:
> > > >
> > > > Well, this usage of generators is a bit uncommon, and may not be a
> > sound design.
> > > > Philippe suggested that you use globaly unique identifiers (GUID)
> > instead of integers.
> > > > They sound like good solution in this case, unless it is
> > absolutely essential to use integers and restart them every year.
> > > >
> > > > --- In firebird-support@yahoogroups.com
> > <mailto:firebird-support%40yahoogroups.com>, Bhavbhuti Nathwani
> > <venussoftop@> wrote:
> > > > >
> > > > > Thanks Philippe, but I am sorry I did not understand what you
> > mean to say I
> > > > > do.
> > > > >
> > > > > Kind regards
> > > > > Bhavbhuti
> > > > >
> >
> > _,___
>
>
> [Non-text portions of this message have been removed]
>