[firebird-support] Firebird on Mac

2014-11-14 Thread 'William, David' david.will...@espn.com [firebird-support]
Hi, I am trying to run Firebird on mac (our standard development platform). I have tried all server packages available on Firebirdsql.org . The installation process runs ok. But whenever I try to start the server, I get this: $ fbguard fbguard: Invalid user (must be firebird, interbase, inte

Re: [firebird-support] sum data into single row per day

2014-11-14 Thread Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]
Thank you Svein, that's what I tried but kept getting: SQL error code = -104. Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause). and yet it now works. I thought it must have been because I was accessing code in the iif(...). I must have

Re: [firebird-support] Cross database update

2014-11-14 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hello Christian, > I am having problems regarding an update skript I want to write that > fetsches data from table1 in db1 and writes the result into exisiting > records in table2 in db2. > To mange this task I am using firebird 2.1.5 and a tool called IBExpert > with a script extension called ibe

Re: [firebird-support] Backup/Restore Required ???

2014-11-14 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
> Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3? Usually this is not needed when the ODS version hasn't been changed (between maintenance releases), but there is a special situation when coming from 2.5.1: http://www.firebirdsql.org/file/documentation/release_notes/html

Re: [firebird-support] Backup/Restore Required ???

2014-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 14 Nov 2014 08:08:59 -0800, "t...@camalot.ca [firebird-support]" wrote: > Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3? > > I have done it here without any issues so far, but thought I better ask > the question. It isn't technically necessary when moving from 2.5.2

[firebird-support] Re: Backup/Restore Required ???

2014-11-14 Thread t...@camalot.ca [firebird-support]
Thanks a bunch. Todd

[firebird-support] Backup/Restore Required ???

2014-11-14 Thread t...@camalot.ca [firebird-support]
Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3? I have done it here without any issues so far, but thought I better ask the question. Todd Brasseur Compass Municipal Services Inc.

[firebird-support] Cross database update

2014-11-14 Thread masb...@za-management.com [firebird-support]
Hi All! I am having problems regarding an update skript I want to write that fetsches data from table1 in db1 and writes the result into exisiting records in table2 in db2. To mange this task I am using firebird 2.1.5 and a tool called IBExpert with a script extension called ibeblock, that lets

Re: [firebird-support] Change Write Mode

2014-11-14 Thread Tiziano tmdevelo...@yahoo.com [firebird-support]
I have found a lot of TIB_Connection and TIBODatabase with ForcedWrites = dpbFalse (now changed to "dpbDefault").Thanks so much for the help!! Il Venerdì 14 Novembre 2014 10:18, "'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]" ha scritto:   > I have different softw

[firebird-support] Re: Why does the optimizer choose NATURAL for this tiny table?

2014-11-14 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
>> D1) ON p.icd10 = t.icd10 >> >> These change the plan to: >> PLAN JOIN (MERGE (SORT (JOIN (P NATURAL, G INDEX >> (I_ICD10_GRUPPE_ICD10))), SORT (JOIN (T KID INDEX (U_NPR_KRG_ID_FNRK), >> T N INDEX (I_NPR_KRG_ID), T T INDEX (I_NPR_TILSTAND_ID_NPR, I >> INDEX (PK_ICD10)) > >Interesting. The

Re: [firebird-support] Change Write Mode

2014-11-14 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> I have different software connected to db: > 1. Delphi + IB_Object/IBO2. Web/WCF + NHibernate + Firebird ADO.NET3. Winforms > + Firebird ADO.NET 4. DB Access (linked to firebird with external table) + > ODBC > It is possible that a data connection change write mode? Yes. In your IBO application

Re: [firebird-support] Change Write Mode

2014-11-14 Thread Tiziano tmdevelo...@yahoo.com [firebird-support]
I have different software connected to db: 1. Delphi + IB_Object/IBO2. Web/WCF + NHibernate + Firebird ADO.NET3. Winforms + Firebird ADO.NET 4. DB Access (linked to firebird with external table) + ODBC It is possible that a data connection change write mode? Il Giovedì 13 Novembre 2014 17:4

RE: [firebird-support] sum data into single row per day

2014-11-14 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
> for select > iif(n.code=1,sum(n.amount),0), > iif(n.code=2,sum(n.amount),0), > iif(n.code=3,sum(n.amount),0), > n.sell_date > from new_table n > where n.sell_date between :fromdate and :uptodate > group by n.sell_date,n.code >

[firebird-support] Firebird can't connect to host

2014-11-14 Thread Andromeda andromedar...@gmail.com [firebird-support]
Hello, I'm new in FirebirdSQL. I can't connect into my host address whereas it can connect to localhost successfully. It prompt show errors like this: SQL> connect "192.168.1.37:/var/lib/firebird/2.5/data/employee.fdb" user 'SYSDBA' password 'masterkey'; Statement failed, SQLSTATE = 08006 Unabl