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 records

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

2012-06-08 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 shorten the

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 Firebird

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

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