RE: Crystal Reoports V9 & MySQL ODBC 3.51.18

Jon,

Many thanks for the link. I have downloaded the document and note that it
says that I need the registry key name for the database and join syntax.
Table A doesn't include the details for MySQL. It refers to contact the
database vendor but I not that you say you have it working for yourself with
V10. Are you able to provide me with that detail for me to write my .reg
file or should I contact MySQL.

Kerry

-----Original Message-----
From: Jon Gallagher [mailto:jongallagher@xxxxxxx]
Sent: 04 August 2004 16:36
To: Kerry Frater; myodbc@xxxxxxxxxxxxxxx
Subject: Re: Crystal Reoports V9 & MySQL ODBC 3.51.18


You have to modify your register to force crystal reports to not use the
{oj...} construct.

Here 's a link to the crystal document that describes the workaround:

http://www.google.com/url?sa=U&start=6&q=http://support.businessobjects.com/
communityCS/TechnicalPapers/cr9_left_outer_join.pdf&e=7385

It works fine for me with CR10 and mySQL 3.51

Jon

Kerry Frater wrote:

>I am just getting into using MySQL and have V9 with the SQL Designer
>downloaded to make life easier in setting up links to do the reports.
>
>I thought I would start with a simple master slave report listing time
>records (timerecords) per job (matters). The SQL designer creates an SQL
>statement shown below.
>
>The ODBC driver provides an error
>You have an error in your SQL syntax. Check the manual that corresponds to
>your MySQL version for the right syntax to use near 'INNER JOIN'
>'LLCOPY'.'timerecords' timerecords ON matters
>
>Although I am happy with databases SQL sytax is a new area. As far as I can
>see the syntax is OK but there obviously isn't or it would work. I don't
>know if the issue is with the MySQL engine or the ODBC driver. The ODBC &
>MySQL installation was taken from the MySQL site 2 days ago from the binary
>production files.
>
>Any help and/or guidance will be gratefully received.
>
>Regards
>
>Kerry
>
>Crystal SQL Designer produced SQL statement
>
>SELECT
>  matters.`MatterRef`,
>  matters.`Description`,
>  timerecords.`Audit`,
>  timerecords.`TimeDescription`,
>  timerecords.`UnitsUsed`
>FROM
>  {oj `LLCOPY`.`matters` matters INNER JOIN `LLCOPY`.`timerecords`
>timerecords ON matters.`MatterRef` = timerecords.`MatterRef`}
>ORDER BY
>  matters.`MatterRef` ASC
>
>
>

--

Jon Gallagher
email: jongallagher@xxxxxxxxxxxxxxxxx
cell: 619-318-5999



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx