[Firebird-odbc-devel] Crystal 8.5

[Kevin S. <kev...@at...>]

Paul, Dimitry -- thanks for the post.  I'm getting back to using Firebird
.9.4 with a Delphi 6 application for the first time in many years (1992).
The VisualLinkingExpert in Crystal 8.5 creates the following code to create
a join between two tables:

SELECT
    PATIENT1."HOMEPHONE", PATIENT1."MOBILEPHONE", PATIENT1."NAMEFIRST",
PATIENT1."NAMELAST", PATIENT1."PATIENTID", PATIENT1."PROVIDERID",
PATIENT1."WORKPHONE",
    PROVIDER1."NAME"
FROM
    { oj "PATIENT" PATIENT1 INNER JOIN "PROVIDER" PROVIDER1 ON
        PATIENT1."PROVIDERID" = PROVIDER1."PROVIDERID"}
WHERE
    PATIENT1."PATIENTID" < 2000
ORDER BY
    PATIENT1."PROVIDERID" ASC,
    PATIENT1."NAMELAST" ASC

and it fails.  If I use the Easysoft ODBC this SQL works ... I can't even
connect using the Intersolv ODBC driver.  The name of the "left" table is
PATIENT and the name of the "right" table is PROVIDER, linking fields of
type Integer (primary key for PROVIDER).  It is my understanding that
Crystal won't allow me to change the SELECT clause. I've selected DIALECT 3,
for no reason other than it seemed newer-cooler than DIALECT 1.  Maybe this
is my problem.

Is there an easier way for me to post?  I copied from the archive and sent
email to fir...@li....

Another, less pressing issue:  Microsoft Products (Access, Excel, Word)
can't access the tables.  This is a problem for me as some of my customers
want to use the MS products to analyze small datasets, do mail merges with
Word, etc.

Thanks,
Kevin



FROM: Paul SchmidtDATE: 02/18/2002 07:06:17SUBJECT: RE:
[Firebird-odbc-devel] Crystal Reports 8.5
Dmitry Yemanov Wrote on 02/15/2002 23:11:04
>Hi Kevin,

> Has anyone tried the ODBC driver with Crystal
Reports?

Dmitry:

I am trying to reply to this, having scraped the text
from the archive, hopefully the result is
understandable.

>Yep, but I wouldn't call it a successful attempt.
>After some debugging, I've
>finally found and fixed the main problem and Crystal
>(I use version 8.0)
>started to work with this driver and my databases,
>but... not exactly the
>way I expected it to work. There's one magic issue I
>still cannot figure
>out. For the time being, I've stopped all my
>investigations due to complete
>lack of time and my changes are still in my private
>source tree, but, once
>the remaining problem is solved, I'll commit the
>changes to the main CVS
>tree or upload them as a separate patch.

Could you send me your source, and let me take a look
at it, sometimes another pair of eyes can help.  I
have an old version of Crystal (4 actually -- planning
to upgrade RSN), and the driver seems to work as is,
except that on a Dialect 3 database dates and times
look really wierd, unless I do really oddball stuff,
like use a view to turn a time into a string field, I
would hate to do that with dates as well, then again
Crystal 4 doesn't support time fields (kind of dumb
IMNSHO).  The main CVS tree is downright ancient, I
was thinking it had actually been abandoned.

Thanks,

Paul