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 [email protected] [firebird-support] wrote:
1) You are using a very old version of Firebird that does not support RECREATE PROCEDURE

Reply via email to