[Lazarus] Zeos Component Join Query

Leonardo M. Ramé l.rame at griensu.com
Tue Jan 12 20:38:51 CET 2010


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







More information about the Lazarus mailing list