[firebird-support] Dynamic SQL Error SQL error code = -104 CTE CTE_CP is not used in query

2015-02-17 Thread Tim Ward t...@telensa.com [firebird-support]
Why?? Why does that have to be a failure?? Why can't Firebird just ignore it?? Is there any switch to turn off this behaviour?? (I've got some immensely complicated query generation code which, it now appears, can occasionally include a common table expression in the query that isn't

Re: [firebird-support] Dynamic SQL Error SQL error code = -104 CTE CTE_CP is not used in query

2015-02-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Tue, 17 Feb 2015 09:41:56 +, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: Why?? Why does that have to be a failure?? Why can't Firebird just ignore it?? Is there any switch to turn off this behaviour?? (I've got some immensely complicated

Re: [firebird-support] Dynamic SQL Error SQL error code = -104 CTE CTE_CP is not used in query

2015-02-17 Thread Tim Ward t...@telensa.com [firebird-support]
On 17/02/2015 09:44, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On Tue, 17 Feb 2015 09:41:56 +, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: Why?? Why does that have to be a failure?? Why can't Firebird just ignore it?? Is there