I can't use several "IFs" becouse I don't know how many generators will be.
when the user create a new category a new generator will be create
automatically.



"ibrahim Bulut" <ibrahim@...> escreveu nas not�cias de
mensagem:003e01c166a1$2c086500$369bc0c6@......

> You must obkect names in stored procedures and trigger.
> You can't use variable object name.
> Interbase doesn't excute this procedure
> Tip:
>
> IF (ID_KIND=1) THEN SEQUENTIAL = GEN_ID(GEN_KIND_1,1);
> IF (ID_KIND=2) THEN SEQUENTIAL = GEN_ID(GEN_KIND_2,1);
> IF (ID_KIND=3) THEN SEQUENTIAL = GEN_ID(GEN_KIND_3,1);
>
>
> ----- Original Message -----
> From: <enio_bueno@...>
> To: <ib-support@yahoogroups.com>
> Sent: Monday, November 05, 2001 3:50 PM
> Subject: [ib-support] choice dynamically a generator
>
>
> > Hi to all
> > I have a table where I need feeling a field with sequential numbers,
> > but
> > this sequential changes to determinate group of registers.
> > -I have for instance this generators
> > GEN_KIND_1 current value set to 500
> > GEN_KIND_2 current value set to 250
> > GEN_KIND_3 current value set to 1500
> > -I have this table
> > CREATE TABLE TESTE
> > (
> > ID INTEGER,
> > ID_KIND INTEGER,
> > SEQUENTIAL INTEGER
> > )
> > if i receive ID_KIND = 2 then sequential must receive 251.
> > I want calculate this generator in stored procedure, but with out use
> > several "ifs", I want do some thing like this
> > ...
> > SEQUENTIAL = GEN_ID("GEN_KIND_" || ID_KIND, 1);
> > ...
> >
> > but intrerbase dont accept this.
> >
> > for while I use a TIBSql to execute this 'SELECT GEN_ID(GEN_KIND_' +
> > ID_KIND,1) FROM RDB$DATABASE', before I call the stored procedure and
> > then I
> > pass the 'SEQUENCIAL' by parameter.
> >
> > so what i really want was calculate all on stored procedure, there
> > are vary
> > concurrency access to insert operations in this table (I consider some
> > danger change directly RDB$GENERATORS)sugestions?
> >
> > thanks to all
> >
> > Enio Bueno
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> >
> >
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>