Subject Re: [IB-Conversions] Problem with store procedure (Interbase)
Author Helen Borrie
At 02:46 PM 30-10-00 -0200, you wrote:
>Hello!
>
>I am run the procedure below and Interbase show me this message :
>"Statement failed, SQLCODE = -104
> Dynamic SQL Error
>-SQL error code = -104
>-Token unknown - line 4, char -1
>-END"
>
>CREATE PROCEDURE Procedure1 AS
>BEGIN
> select * from table
>END
>
>What's the problem ?
>


Every statement needs to end with a semi-colon.
CREATE PROCEDURE Procedure1 AS
BEGIN
select * from table ;
END

H.
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
___________________________________________________