Not even like
1. Start transaction exclusively locking counter record
2. Read current value, increment, write back, use etc
3. Commit transaction effectively unlocking record
?

--- In firebird-support@yahoogroups.com, Milan Tomeš - Position <tomes@...> wrote:
>
> Because of transaction control it cannot be succesfully done.
>
> Milan
>
> Dne 29.04.2010 11:30, zvjezdantomicevic napsal(a):
> >
> > 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
> > <mailto:firebird-support%40yahoogroups.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>
> > > > <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>
> > > > <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>
> > > > <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]
> > >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>