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:

SQL> input c:\databases\test.sql;
Statement failed, SQLCODE = -206

Dynamic SQL Error
-SQL error code = -206
-Column unknown
-TEST2
-At line 5, column 3.
SQL>

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

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."