Subject Re: [firebird-support] RECREATE Procedure issue.
Author Joje
I am using firebird 2.5.5 version. As my application is .net application I am using Firebirdclient.dll to interact with firebird database. Also I am executing the query inside my .net application.
There are many queries in my .net application, only this 'RECREATE' query fails to execute while others get executed successfully.

Later when I ran this query in my third party SQL Manager it failed to execute in it.
 The error shown in SQL manager was
"Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Unexpected end of command - line 30, column 36."

at declaration statement "DECLARE VARIABLE COUNT INTEGER;"

NOTE: When same query executed with 'ALTER', it got executed successfully.

On 17-03-2016 23:48, Helen Borrie helebor@... [firebird-support] wrote:
1) You are using a very old version of Firebird that does not support RECREATE PROCEDURE