Mysql - Crystal Report

Hello Miguel




I am trying to migrate from MSSQL 2000  to MYSQL 4.1.1a and i am having 
problems with
Crystal Report because when I use more than 2 tables in the same reports it 
show me an error

    ODBC ERRRO:[mysql][odbc 3.5.1 driver][mysql 4.1.1a-alpha]
    you have an error in your SQL Syntax etc.....

this is the SQL Query

SELECT
    pedpt1.`PdFecha_Despachar`,
    penpt1.`Pnpedido`, penpt1.`Item_No`,
    items1.`Item_Desc_1`
FROM
    { oj (`Manutex`.`pedpt` pedpt1 INNER JOIN `Manutex`.`penpt` penpt1 ON
        pedpt1.`PdPedido` = penpt1.`Pnpedido`)
     INNER JOIN `Manutex`.`items` items1 ON
        penpt1.`Item_No` = items1.`Item_No`}

and this is the error



On Wed, 2003-06-04 at 11:41, Director General: NEFACOMP wrote:
> Me, I have failed to report on pictures stored in Blob fields.

Thanks for the report, will be looking at this shortly.


> 
> 
> Thanks
> Emery
> ----- Original Message ----- 
> From: "Miguel A. Gonzalez" <miguelg@xxxxxxxxxxxxx>
> To: <myodbc@xxxxxxxxxxxxxxx>
> Sent: Wednesday, June 04, 2003 22:18
> Subject: MyODBC and MSSQL and Crystal Reports
> 
> 
> > I have just started doing some reports with MySQL and Crystal Reports
> > and have found what I believe may be bug with crystal reports.  I wanted
> > to post it in here because I know there are quite a few people using
> > crystal/mysql and may encounter this problem.
> > 
> > The problem occurs when you try to link two tables and the fields you
> > are trying to link are unsigned int (in my case these were
> > auto_increment fields), crystal will not link them properly.  You have
> > to make it a signed integer or else it will not link the fields
> > properly.
> > 
> > Just what I have found out :) Hopefully it will save somebody a few
> > hours of playing around.
> > 
> > --Miguel
> > 
> > 
> > -- 
> > MySQL ODBC Mailing List
> > For list archives: http://lists.mysql.com/myodbc
> > To unsubscribe:    http://lists.mysql.com/myodbc?unsub=1

Enviado a traves de CorreoWeb Calipso Comunicaciones S.A.


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