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 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 (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 thomas.beckmann@... <mailto:thomas.beckmann@...>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
info@... <mailto:info@...> • 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.