Re: SV: [firebird-support] Re: Grouping without sorting alphabetically

2015-02-17 Thread Venus Software Operations venussof...@gmail.com [firebird-support]

Re: [firebird-support] How to join records

2015-02-17 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 17, 2015, at 7:26 AM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote: Could Common Table Expressions or Derived Tables bring any advantages? I suppose you could use a combination of the two suggestions: [good

[firebird-support] Yet another which architecture question

2015-02-17 Thread Tim Ward t...@telensa.com [firebird-support]
Sorry, you must all be really bored with these, but I just can't get my head round it. We're looking to upgrade our (Linux) operating system, and with that is likely to come an upgrade from 32 bit Firebird 2.1 Superserver to 64 bit Firebird 2.5, but what architecture? We need more performance

[firebird-support] transaction rollback on client disconnect or timeout

2015-02-17 Thread harald...@yahoo.com [firebird-support]
Hi, we have a problem with applications of third party suppliers. We provide a database for data exchange between our system and a third party system. It often occurs, that the third party suppliers leave transactions open without committing them. This leads of course to a transaction diff and

[firebird-support] Automatic Transaction/Attachment closure on client connection lost or timeou

2015-02-17 Thread harald...@yahoo.com [firebird-support]
Hi, we have a problem with third part systems connection to our DB. Actually we provide a database for data exchange between our system and third party systems. The problem is, that sometimes the third party systems leave transactions open. Of course this leads to a transaction diff, ending in

[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