Subject | Re: [IB-Conversions] Problem with store procedure (Interbase) |
---|---|
Author | Helen Borrie |
Post date | 2000-10-31T01:29:42Z |
At 02:46 PM 30-10-00 -0200, you wrote:
CREATE PROCEDURE Procedure1 AS
BEGIN
select * from table ;
END
H.
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
___________________________________________________
>Hello!Every statement needs to end with a semi-colon.
>
>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 ?
>
CREATE PROCEDURE Procedure1 AS
BEGIN
select * from table ;
END
H.
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
___________________________________________________