[firebird-support] HP 200LX .gdb files?

2015-04-08 Thread lmcelhi...@yahoo.com [firebird-support]
Hi Folks, I am searching for a Macintosh OS X solution which supports .gdb database files from the Hewlett Packard HP 200LX Palmtop. I understand that Firebird can be installed on OS X, but need to know if there might still be support for the .gdb files produced by the 200LX. (I belong to

Re: [firebird-support] HP 200LX .gdb files?

2015-04-08 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Larry, I am searching for a Macintosh OS X solution which supports .gdb database files from the Hewlett Packard HP 200LX Palmtop. I understand that Firebird can be installed on OS X, but need to know if there might still be support for the .gdb files produced by the 200LX. (I belong to an

Re: [firebird-support] Database Size Is Not Reducing

2015-04-08 Thread marcus mar...@antiphasis.net [firebird-support]
On 07.04.2015 08:16, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: Then what could be the best way to reduce the database size? All suggestions are appreciated. Hej Vishal played around a little bit, unable to reproduce your problem. Even after setting some blobfields

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

2015-04-08 Thread ryanash...@hotmail.com [firebird-support]
How do I know which directory the remove.sh file is in? Can I find it from within the Finder? How do I find it using Terminal? How do I change directories to get into the directory that the file is in?

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

2015-04-08 Thread ryanash...@hotmail.com [firebird-support]
I tried it out and it said the following: Ryans-MacBook-Pro:~ ryanashton1$ ./remove.sh Launchctl /Library/LaunchDaemons/org.firebird.gds.plist: Could not find specified service Remove Framework Remove Receipt Remove /tmp/firebird

RE: [firebird-support] Recursive CTE question

2015-04-08 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Can the question be rephrased as you being interested in which sets are identical, Elias? If I understand things correctly, I would assume double negation to be the simple answer you're looking for: with tmp(id) as (select distinct id from CRITICALPARAMVALS) select t.id, t2.id from tmp t join

RE: [firebird-support] V1.56 query killing my V2.54 app

2015-04-08 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Ok, used the +0 and worked. On v1.56 I was used with setting up a high granularity data column (col04Int - part of the primary key) with a True/false (0/1) type of column (ColDetSmIntFlag) to boost the selectivity of the index IXColDetSmIntFlag. I kept the index with that configuration for a

Re: [firebird-support] V1.56 query killing my V2.54 app

2015-04-08 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 07 Apr 2015 08:51:22 -0700, andrew_s_...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: Hi all, I'm trying to upgrade an app to v2.54 from v1.56 but there are some queries that aren't planning the way they should. I've been changing the query and trying to

Re: [firebird-support] Re: V1.56 query killing my V2.54 app

2015-04-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Apr 8, 2015, at 10:05 AM, andrew_s_...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: Let's see when histograms come to the party, it'll make things more interesting for sure. G Histograms may be less useful in Firebird than you might think, unless there's a

[firebird-support] Re: V1.56 query killing my V2.54 app

2015-04-08 Thread andrew_s_...@yahoo.com [firebird-support]
Hi Mark, Yes, I did a Backup/Restore and updated all the index statistics to give the engine the best chances possible for the select... Thanks. Andrew

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

2015-04-08 Thread 'Paul Beach' pabe...@waitrose.com [firebird-support]
I tried it out and it said the following: Ryans-MacBook-Pro:~ ryanashton1$ ./remove.sh Launchctl /Library/LaunchDaemons/org.firebird.gds.plist: Could not find specified service Remove Framework Remove Receipt Remove /tmp/firebird Then the sh file has done nearly all its job... the comments

[firebird-support] Re: V1.56 query killing my V2.54 app

2015-04-08 Thread andrew_s_...@yahoo.com [firebird-support]
Hi Set, (I assume you have optimized poorly performing queries with Fb 1.5 long ago, rather than been waiting for the upgrade). Yes. If you compare new, unoptimized queries between 1.5 and 2.5, odds are that you would conclude that 2.5 are better. I have very high expectations for that.

[firebird-support] SQL puzzle: Order based on Prerequisite

2015-04-08 Thread firebirdbest...@yahoo.com [firebird-support]
In a table called Steps, I have the following fields: ID, B4Me, Dsc, -ID field contains a unique ID for each record -B4Me contains the ID of some other record in the table that MUST appear in a result set, BEFORE this record. B4Me may be null. This is called the B4Me order. -Records

[firebird-support] Re: V1.56 query killing my V2.54 app

2015-04-08 Thread andrew_s_...@yahoo.com [firebird-support]
Hello Ann, Firebird 1.5 considered the index a good candidate, even if you only matched the first part. In later, smarter versions, it recognizes that the first part alone is not very good. I did change the index to only the boolean 1/0 field... then I changed back adding a part of the