Hi Claudio,

> "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?

The procedure does not yet exist.

I've just tried:

CREATE ...

works fine.

DROP ...

CREATE ...

works fine.

RECREATE ...

same error :(

If you need to know more, let me know.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com


[Non-text portions of this message have been removed]