[Firebird-odbc-devel] Crystal 8.5 problem with latest changes and OUTER JOIN

[Pier A. G. <pgu...@an...>]

I'm testing the latest changes with Crystal Reports 8.5.
I've seen a strange behaviour when using OUTER JOINS.
With previous version of the driver, OUTER JOINS were treated in the right
way by adding the following key in the registry:

HKEY_CURRENT_USER\Software\Seagate Software\Crystal
Reports\DatabaseOptions\OuterJoin = 'odbcjdbc'.

I downloaded the latest changes from CVS tree and recompiled them. Then I
tested the driver with Crystal.
Now OUTER JOINS are treated in a bad way, like this:

SELECT
    PERSON1.CODICE, PERSON1.NOME,
    ENTI1.CODICE, ENTI1.DESCRIZION
FROM
    { oj PERSON PERSON1 LEFT OUTER JOIN ENTI ENTI1 ON
        PERSON1.ENTE = ENTI1.CODICE}

The Oj operator is added to the query. It seems the registry key is ignored
by Crystal with the new version of driver, but why?

Regards,

Ing. Pier Alberto GUIDOTTI
ANALYSIS s.r.l.
Via Zanardi 403/23B
40131 BOLOGNA (ITALY)
http://www.analysisbo.it