At 12:55 PM 22/01/2009, you wrote:

>Good Morning!
>
>I am trying to alter a table and two procedures in a FB 2.1.0.17798
>database.
>
>This is a test db and app so that I can learn how and then apply the
>techniques to a production db.
>
>I can add a field to the table and alter the 'put' procedure, but when
>I try to alter the 'get' procedure, I get this:
>"Project DBTest.exe raised exception class EIBInterBaseError with message
>'Dynamic SQL Error SQL error code = -104 Token unknown - line 1,
>column 183 ?'.
>Process stopped. Use Step or Run to continue."
>
>This is the alter statement:
>ALTER PROCEDURE GETTABLE1DATA RETURNS( F1 INTEGER, F2 VARCHAR(20)
>CHARACTER SET WIN1251, F3 varchar(10) CHARACTER SET WIN1251) AS
>BEGIN for Select * from table1 into :F1, :F2, :F3 Do
>SUSPEND; END;
>
>When I execute this statement in SQL Manager 2005, the procedure is
>altered.
>
>Is that error message referring to the '?' or to something else?

It is referring to the semi-colon after the final END statement of the procedure definition. It's not legal syntax and is therefore an "unknown token".

./heLen