Subject ALTER PROCEDURE problem
Author Dan Statham
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?

Can anyone either show me what is wrong or point me in the right
direction?

Thanks...Dan'l