[Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016

2016-10-12 Thread STÜBER SYSTEMS
Hello, When it comes to execute a crystal reports file in the -most cases- (not all) this error is thrown: Fehler beim Öffnen eines Rowsets. (english: Error opening rowset) Details: HY000:[ODBC Firebird Driver][Firebird]Dynamic SQL Error SQL error code = -104 Token unkown - line 1, column 1165 .

Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016

2016-10-13 Thread STÜBER SYSTEMS
An: firebird-odbc-devel@lists.sourceforge.net Betreff: Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016 12.10.2016 16:04, Antonio Cambule (STÜBER SYSTEMS) wrote: > Any idea if this can be solved? Turn on server-side trace and see what is the real query af

Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016

2016-10-13 Thread STÜBER SYSTEMS
Y "Lehrer"."Mandant", "Lehrer"."Nachname", "Lehrer"."Vorname" And the error is on this line: FROM (((" "."AuswahlLehrer" "AuswahlLehrer" LEFT OUTER JOIN " "."Lehrer" "Lehrer"

Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016

2016-10-31 Thread STÜBER SYSTEMS
autoquoted identifier. Regards Pablo On 10/13/2016 05:10 AM, Antonio Cambule (STÜBER SYSTEMS) wrote: Hi Pablo, I did that and got the same error. Here is the Query without that SELECT "Lehrer"."Nachname", "Lehrer"."Vorname", "Lehrer"."Telefon&quo