| Subject | Re: [firebird-support] RECREATE Procedure issue. |
|---|---|
| Author | Joje |
| Post date | 2016-03-18T08:01:09Z |
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.
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