"Martijn Tonies" <martijn@...> wrote in message
news:C1FE56B5C29FD211A99F00A0244BE820096159@SRV_BISIT...

> Hi all,
>
> I'm running the following command on a WI-T6.2.567 Firebird RC1 server:
>
> SET TERM ^! ;
>
> RECREATE PROCEDURE USP_TEST
> AS
> DECLARE VARIABLE TEST2 INTEGER;
> BEGIN
> TEST2 = GEN_ID(USER_ID, 1);
> END ^!
>
> set term ;^!
>
> The generator USER_ID exists, but the command fails with message:

What happens if you use a DROP statement followed by a CREATE statement? Can
you repeat the fail with RECREATE after that?

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing