[firebird-support] Very Strange: Query giving different results

Hi, we have found a very strange problem with our firebird database, a record on a table of firebird databes is not always beeing returned: 1 - Using flamerobin we are never fetching record 1648 of our datble. 2 - Using an application we are developing (with vb.net on vs2010)

[firebird-support] Support for OS X 10.11 El Capitan

Hello Paul, do you have an idea, when the packager will be supported El Capitan or is any other way manually to install firebird? Thanks for you help Bernd Frei

Re: Re: [firebird-support] How To Get Entire Linked Group Details

Hi Norbert, Sorry to say, but the below SQL you shared doesn't givbe the sub nodes in the base node, it just gives the first level of nodes and not the enitre node structure i.e. all other nodes below the nodes (i.e. nodes which I get from you SQL as a result ) are missing. Would you please

Re: Re: [firebird-support] How To Get Entire Linked Group Details

Sorry, forgot to put SQL for reference.  if I understand the request, something like select b.description from(select a.* from mygroup awhere  a.linked_to_group is not nulland(exists(select 1 from mygroup b  where  b.linked_to_group = a.pk_group )or a.linked_to_group != (select first 1 pk_group

Re: Re: [firebird-support] How To Get Entire Linked Group Details

Hi Norbert, The SQL you have shared without CTE, gives me other group details as well if they exists. If you create another base group like 'Vishal Group', then this SQL gives that group details as well. I tried but putting group name in condition but getting only one record, could you show me

Re: [firebird-support] Very Strange: Query giving different results

On Mon, Oct 5, 2015 at 12:59 PM, 'Alexis (PROINTER)' ale...@prointersl.com [firebird-support] wrote: > Hi, we have found a very strange problem with our firebird database, a > record on a table of firebird databes is not always beeing returned: > > 1 - Using

[firebird-support] DATA COMPARISON

Hi All Is there a query structure available I can use to identify where records have been change or are missing between two table with the exact table structure? i.e. I store a backup of financial data annually in separate tables. JOURNAL2013 JOURNAL2015 JOURNAL2015 etc. where

RE: Re: [firebird-support] How To Get Entire Linked Group Details

if I understand the request, something like select b.description from ( select a.* from mygroup a where a.linked_to_group is not null and ( exists(select 1 from mygroup b where b.linked_to_group = a.pk_group ) or a.linked_to_group != (select first 1 pk_group from mygroup where

Re: Re: [firebird-support] How To Get Entire Linked Group Details

Hi Norbert, Thank You So Much, I got exactly the same result what I was expecting. Thank You So much. Are you aware of any documents which are avaialble in english, so I could learn this recirsive SQL ? With Best Regards. Vishal On Monday, 5 October 2015 3:55 PM, "'Norbert Saint Georges'