Re: [Firebird-odbc-devel] ODBC V1.1 and Crystal Reports

[Vladimir T. <pr...@hm...>]

Hello,

>
> This will display a window containing the actual query used by Crystal
> Reports.  If you have set up your ODBC connection in step 1 above using
> OdbcJdbc you will notice the number 1 added to table names - change to
> another driver (Gemini or Easysoft) and this doesn't happen.

    No!!!
    It's not bug OdbcJdbc ;-)
=========================
SELECT
    CUSTOMER1."CUSTOMER",
    SALES1."PO_NUMBER", SALES1."TOTAL_VALUE",
    COUNTRY1."COUNTRY"
FROM
    { oj ("CUSTOMER" CUSTOMER1 INNER JOIN "COUNTRY" COUNTRY1 ON
        CUSTOMER1."COUNTRY" = COUNTRY1."COUNTRY")
     INNER JOIN "SALES" SALES1 ON
        CUSTOMER1."CUST_NO" = SALES1."CUST_NO"}
==========================
CUSTOMER1 <---------- it's alias table CUSTOMER!!!

Your base has default dialect 1
This dialect is not able to process such inquiries!

Thank for a good example!
Very well, now I precisely know as to add in DSN option Dialect!
The reason in that that OdbcJdbc has not switch options Dialect (1,3)

I shall add this option and I shall inform in addition.

--
Best regards,
Vladimir Tsvigun