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