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