--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:

> You also do not need a table really
> This procedure will do the same thing when you
> SELECT NEXTJRECNO FROM GETNEXTJRECNO;
>
> CREATE PROCEDURE GETNEXTJRECNO
> RETURNS (
> NEXTJRECNO INTEGER)
> AS
> BEGIN
> NEXTJRECNO = GEN_ID(JRECNO_GEN, 1);
> SUSPEND;
> END

This looks like a good idea, but one would need a separate SP for
every generator then, right?

Milan B.