[firebird-support] RECREATE Procedure issue.

2016-03-20 Thread Joje j...@codework-solutions.com [firebird-support]
Hi All, I am facing a issue with 'RECREATE' procedure. Problem: I have a stored procedure that uses '*RECREATE *Procedure', this procedure does not execute properly when executed in EMS SQL manager for IB and Firebird. Dont know why... :( every time i execute it. Procedure execution

Re: [firebird-support] RECREATE Procedure issue.

2016-03-20 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2016-03-17 15:49, Joje j...@codework-solutions.com [firebird-support] wrote: > Hi All, >  I am facing a issue with 'RECREATE' procedure. > > Problem: > I have a stored procedure that uses 'RECREATE Procedure', this > procedure does not execute properly when executed in EMS SQL manager > for

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Joje j...@codework-solutions.com [firebird-support]
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

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Helen Borrie hele...@iinet.net.au [firebird-support]

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello j...@codework-solutions.com, Saturday, March 19, 2016, 11:51:23 PM, you wrote: > Regarding thus issue could someone raise a ticket & update the documentation > of firebird. Not necessary. The documentation is under review at this stage. I have added warnings to both RECREATE PROCEDURE

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Joje j...@codework-solutions.com [firebird-support]
I am executing this query using my .net application and it is not throwing any error. If there was a error then it would log that error and will display it to the user. I executed this query in my third party SQL Manager and it throws an error /Invalid token.// //Dynamic SQL Error.// //SQL

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2016-03-18 9:10, Joje j...@codework-solutions.com [firebird-support] wrote: > I am executing this query using my .net application and it is not > throwing any error. If there was a error then it would log that error > and will display it to the user. If it is not throwing an error, then I

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 19-3-2016 11:51, j...@codework-solutions.com [firebird-support] wrote: > Regarding thus issue could someone raise a ticket & update the > documentation of firebird. You can create tickets at http://tracker.firebirdsql.org/browse/DOC Mark -- Mark Rotteveel

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread j...@codework-solutions.com [firebird-support]
Regarding thus issue could someone raise a ticket & update the documentation of firebird. Sent from Outlook Mobile On Sat, Mar 19, 2016 at 12:15 AM -0700, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" wrote:  

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 19-3-2016 04:44, j...@codework-solutions.com [firebird-support] wrote: > If it's not executing then it should send a message. Also I referred the > site documentation of recreate procedure. But there was no specific info > about dependency in stored procedure. > > But later when I referred the

Re: [firebird-support] RECREATE Procedure issue.

2016-03-18 Thread j...@codework-solutions.com [firebird-support]
bird-support] Sent: Friday 18 March 14:43 Subject: Re: [firebird-support] RECREATE Procedure issue. To: Mark Rotteveel m...@lawinegevaar.nl [firebird-support]   On 2016-03-18 9:10, Joje j...@codework-solutions.com [firebird-support] wrote: > I am executing this query using my .net appl