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

[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 stuc

[firebird-support] Compiling stored procedure while database in production

2016-03-20 Thread mailgro...@murdochfl.com [firebird-support]
I had a strange coincidence today, but I'm wondering if it actually may have been cause/effect instead. I'm running fb_inet_server.exe 2.5.2.26539 on Windows 2008 Server. Earlier today I created a simple "for select do update" stored procedure against a database that may have had 20-25 open co

[firebird-support] Temporarily disable constraints

2016-03-20 Thread Robert martin r...@chreos.com [firebird-support]
Hi Is it possible to temporarily disable a FK constraint? I have found a couple of requests for this feature dated 2009 but these still show as open. Did this functionality ever get implemented ? It would save me a lot of work :) Thanks Rob

RE: [firebird-support] Temporarily disable constraints

2016-03-20 Thread 'Alan McDonald' a...@meta.com.au [firebird-support]
Hi Is it possible to temporarily disable a FK constraint? I have found a couple of requests for this feature dated 2009 but these still show as open. Did this functionality ever get implemented ? It would save me a lot of work :) Thanks Rob It's easy enough to drop them all then re-create

Re: [firebird-support] Temporarily disable constraints

2016-03-20 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hi, > Is it possible to temporarily disable a FK constraint? I have found a > couple of requests for this feature dated 2009 but these still show as > open. Did this functionality ever get implemented ? No. As Alan said, currently the only way is to dropping and re-creating. -- With regards,