Hi,

I'm not sure you're able to use "select * ... into" in a store proc

did you try "select f1, f2, f3 from... into :f1, :f2, :f3" ?

Thierry

Dan Statham a écrit :

>
> 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 lear 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?
>
> Helen B said it was the ending colon. I get the same error without the
> colon.
>
> I am using Delphi 6 and TIbQuery.
>
> Thanks...Dan'l
>
>