Re: [firebird-support] how to put null at the end in oder by ASC

2011-09-02 Thread Ann Harrison
On Fri, Sep 2, 2011 at 6:24 PM, Markus Ostenried wrote: > On Fri, Sep 2, 2011 at 19:21, Vander Clock Stephane > wrote: > > > but i need the index :( > > What's the performance if you use an (ugly) hack like this: > > Create a column NULLFLAG (with values 0 and 1) with an index on it and > in a tr

Re: [firebird-support] how to put null at the end in oder by ASC

2011-09-02 Thread Markus Ostenried
On Fri, Sep 2, 2011 at 19:21, Vander Clock Stephane wrote: > unfortunatly > > If you override the default NULLs placement, no index will be used for > sorting. In Firebird 1.5, > that is the case with NULLS FIRST. In 2.0 and higher, with NULLS LAST on > ascending and > NULLS FIRST on descending so

Re: [firebird-support] OSX GUI's

2011-09-02 Thread Markus Ostenried
On Fri, Sep 2, 2011 at 21:08, samcarleton wrote: > Are there any OSX GUI's for Firefox? FlameRobin is a cross-platform GUI administration tool for Firebird: http://www.flamerobin.org/

[firebird-support] Re: OSX GUI's

2011-09-02 Thread samcarleton
Sean, My bad, it was a mistype, I mean firebird. --- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote: > > > > Are there any OSX GUI's for Firefox? > > Firefox??? > > This is a **Firebird** SQL database group/mailing list. > > > Sean >

Re: [firebird-support] how to put null at the end in oder by ASC

2011-09-02 Thread Gordon Niessen
On 9/2/2011 12:21 PM, Vander Clock Stephane wrote: > > unfortunatly > > If you override the default NULLs placement, no index will be used for > sorting. In Firebird 1.5, > that is the case with NULLS FIRST. In 2.0 and higher, with NULLS LAST on > ascending and > NULLS FIRST on descending sorts.

RE: [firebird-support] OSX GUI's

2011-09-02 Thread Leyne, Sean
> Are there any OSX GUI's for Firefox? Firefox??? This is a **Firebird** SQL database group/mailing list. Sean

[firebird-support] OSX GUI's

2011-09-02 Thread samcarleton
Are there any OSX GUI's for Firefox?

Re: [firebird-support] how to put null at the end in oder by ASC

2011-09-02 Thread Vander Clock Stephane
unfortunatly If you override the default NULLs placement, no index will be used for sorting. In Firebird 1.5, that is the case with NULLS FIRST. In 2.0 and higher, with NULLS LAST on ascending and NULLS FIRST on descending sorts. but i need the index :( On 8/31/2011 12:17 AM, Mark Rotteveel w

Re: [firebird-support] Why drop table can be sometime very very long ?

2011-09-02 Thread Vander Clock Stephane
thanks ann ! On 8/30/2011 11:52 PM, Ann Harrison wrote: > > Stephane, > > > > > > > when i do drop table, sometime it's take hours to return > (especially on > > > > big table) > > > > why ? > > > > > > > no, the database have only one client connected, the client that do the > > drop table ... >

Re: [firebird-support] mac os x: aliases.conf

2011-09-02 Thread Point Informática - Dep. de Desenvolvimento
Thanks, Now I can connect into firebird server, the problem is the plist file in /Library/Framework, but the problem now is permission! The permission of my file is 777, but when I try to connect other computer using ibexpert show me: Permission Denied. Unsuccessful execution caused by a sys

Re: [firebird-support] mac os x: aliases.conf

2011-09-02 Thread Matthias Zitzen
Original-Nachricht Betreff: Re: [firebird-support] mac os x: aliases.conf Datum: Fri, 02 Sep 2011 15:27:11 +0200 Von: Matthias Zitzen An: firebird-support@yahoogroups.com Hi, Am 01.09.2011 21:24, schrieb "Point Informática - Dep. de Desenvolvimento": > I just have problem to

[firebird-support] Error to connect in Firebird Classic Server into MacOs

2011-09-02 Thread Point Informática - Dep. de Desenvolvimento
Hello, When I try to connect into my server, with is instaled in MacOS system, I receive this error: Trying ::1... telnet: connect to address ::1: Connection refused Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. Sep 2 09:05:06 MacMini.local launchproxy[1