<FHector@w...> wrote:

> >>CREATE PROCEDURE G (GNAME VARCHAR(31), GSTEP INTEGER)
> >> RETURNS (GVAL BIGINT) AS
> >>BEGIN
> >> EXECUTE STATEMENT 'SELECT GEN_ID(' || UPPER(:GNAME) || ', '
> >
> > || :GSTEP || ') FROM RDB$DATABASE'
> >
> >> INTO :GVAL;
> >>END
> >>
> >>Ivan
> >
> >
> > Obviously you havn't tried this...it doesn't work.
> >
>
>
> Sure does it work, just tried it:

My results are in line with the developer said.

http://groups.yahoo.com/group/firebird-support/message/62039?
threaded=1