Re: [firebird-support] Select statement

2012-10-17 Thread Magnus Titho
Am 17.10.2012 13:47, schrieb Nols Smit: > Hi, > > I have a table, let's call it TENDERS. It has the following fields: ID, > Date_Closing, Value (ID is the pimary key). > > How do I select the the records in TENDERS where either Date_Closing or Value > or both is null but also including those r

Re: [firebird-support] How to shorten =================================== between header and data rows?

2012-06-07 Thread Magnus Titho
Am 08.06.2012 02:51, schrieb ehaerim: > SQL> select substring(data_feed_name from 1 for 10) dfn from test; > [...] > I want the = to be shortened to 15 so that it > looks like > > DFN > === > InvestWare Strange request. Anyway, you could use cast to shorte

Re: [firebird-support] Setup files needed

2012-04-23 Thread Magnus Titho
Am 20.04.2012 14:50, schrieb Steve Harp: > Hi Guys, > > > > The INNO script for Firebird (FirebirdInstall_20.iss) uses 2 files > (vccrt8_Win32.msi& vccrt8_x64.msi) that I've not been able to find. Could > anyone please provide the link where I can download these files? You can find them in the Fi

Re: [firebird-support] How to store value in different currency ?

2012-04-10 Thread Magnus Titho
Am 09.04.2012 19:44, schrieb nathanelrick: > How do you handle this ? actually i store all the value in EUR in the > database with a field EUR2CurrencyRate ... and every week i update the value > in EUR with the new exchange rate. it's too much intensive as i need to scan > every week all the da

Re: [firebird-support] Access a Firebird database on another LAN Computer

2012-01-30 Thread Magnus Titho
Am 30.01.2012 20:33, schrieb chervenokos: > I do try the following syntax for LAN-connection: > 192.168.1.2:C:\Users\emo\!EMIL\DB\SOSIFB214.FDB > but the connection fails .. My guess: You haven't installed Firebird on the other computer (192.168.1.2). -- Magnus

Re: [firebird-support] MS Access ODBC to Firebird

2012-01-20 Thread Magnus Titho
Peter M wrote: > I cannot get a result on the Test Connection. I have tried every syntax for > the db name, with no change. > > Path isP:\AdminBase\Database\ADMINBASE32.GDB > Is P: a local drive of the server or a mapped drive? Don't use mapped drives as pathnames! -- Magnus