[Lazarus] cross compile from windows

[Kjow]

Thank you for reply Leonardo.

I'm using SqLite. I tested the query with sqlite command line tool. The
query is correct. The problem is Zeos.



2010/1/12 Leonardo M. <l.rame at griensu.com>

> Massimo, please before trying with Lazarus/Zeos, please test your query
> using an external database administration tool like FlameRobin or
> IbExpert of you are using Firebird.
>
> 99% of the time, the problem isn't Zeos, but the query itself.
>
> --
> Leonardo M. Ramé
> Griensu S.A. - Medical IT Córdoba
> Tel.: 0351-4247979
>
> El mar, 12-01-2010 a las 18:07 +0100, Massimo Fazzolari escribió:
> > Hi,
> >
> > I have two tables:
> >
> >   - Customers
> >   - Invoices
> >
> > I got an sql logic error trying to execute following query using Zeos
> > Component (ZQuery):
> >
> > "SELECT Invoices.*, Customers.Name
> >  FROM Invoices
> >  LEFT JOIN Customers
> >  ON Invoices.CustomerID= Customers.ID
> >  WHERE Customers.Name = 'Tom' "
> >
> > excluding the Where clause make the query run without problems.
> >
> > Thank you
> > Max
> > --
> > _______________________________________________
> > Lazarus mailing list
> > Lazarus at lists.lazarus.freepascal.org
> > http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>
>
>
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20100113/ac5d9b38/attachment-0004.html>