One thing, that corresponds to Seans ideas: Formely you could used mixed alias and table name in field list. Now, you've to be strict: Assign alias and use alias (or no qualifier) or do not assign alias.
I.e.: select t.C from tab t -- works select tab.C from tab -- works select C from tab -- works select C from tab t -- works select tab.C from tab t -- does not work Might a hint in your case... Thomas Am 08.05.2014 22:53, schrieb [email protected]: > > > 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 (it was saved earlier on the 1.5 system using gbak as well). > > > The client seems to be running fine on the new system for the most part > except when I try to run a few internal reports where I get te following > error from the client... > > General SQL error. > > Column known. > > MyTable.MyField > > I checked the table structure in both versions using FlameRobin and they > both looked the same and MyField exists in both tables. > > > Are there any incompatibilities between the 1.5 and 2.5 formats that > would cause this ? Unfortunately, I don't have access to the client code > so its a bit of a shot in the dark but any advice would be greatly > appreciated. > > > thanks, > > -- Mit freundlichen Grüßen, Thomas Beckmann Diplom-Informatiker Wielandstraße 14c • 23558 Lübeck Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604 Mail [email protected] <mailto:[email protected]> ASSFINET-Logo *ASSFINET Dienstleistungs-GmbH* Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn [email protected] <mailto:[email protected]> • www.assfinet.de <http://www.assfinet.de/> Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann Registergericht Koblenz HRB 23331 Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
