[firebird-support] Column Unknown FB 1.5-2.5

2014-05-08 Thread srotyliano
I have a legacy client that was running fine on XP with FB 1.5 but we've recently switched the PC out for a Win7 Pro 64 bit system. In order to get the client running on the Win7 system I installed FB 2.5 on it and used gbak on the new system to restore the database file as a 2.5 version

[firebird-support] Re: Column Unknown FB 1.5-2.5

2014-05-08 Thread srotyliano
One other bit... I didn't use the -TRANSPORTABLE switch when I created the backup file on the 1.5 system Could this have something to do with the error ?

Re: [firebird-support] Cannot log into database

2014-04-23 Thread srotyliano
Thanks for your comments. Lots to learn here and your comments are a great help. I was able to resolve the issue overnight. I first backed up the 1.5 fdb file with gbak, then installed FB 2.5 on the WIN7 system and used gbak to restore and convert the fdb file it to a 2.5 version. This works

[firebird-support] Cannot log into database

2014-04-22 Thread srotyliano
I don't know if this is Firebird or a BDE issue but I am trying to port a legacy client that runs on FB 1.5 from an XP system to a WIN7 (64 bit) system. I was able to install FB 1.56, the client software with its fdb onto the WIN7 system. I also had to install BDE 5.01 since that is what the

[firebird-support] Re: Queries for 3 or more tables

2012-09-01 Thread srotyliano
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On 31-8-2012 15:33, srotyliano wrote: What is the best way to script a query for combining data from 3 or more tables ? ver: Firebird 1.5 Could you elaborate on what you want to achieve? Normally you would use

[firebird-support] Re: Queries for 3 or more tables

2012-09-01 Thread srotyliano
- Original Message - From: srotyliano srotyliano@... To: firebird-support@yahoogroups.com Date: Sat, 01 Sep 2012 14:16:34 - Subject: [firebird-support] Re: Queries for 3 or more tables Thanks for the reply Mark. Using your format I tried... select * FROM jobs INNER

[firebird-support] Queries for 3 or more tables

2012-08-31 Thread srotyliano
What is the best way to script a query for combining data from 3 or more tables ? ver: Firebird 1.5 Steve