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.r...@griensu.com
Massimo, please before trying with Lazarus/Zeos, please test your query
using an external database
On Wednesday 13 January 2010 11:26, Massimo Fazzolari wrote:
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.
I'm using ZEOS for years, and it works correct (postgresql). Such query (as
mentioned
Hello Lazarus-List,
Wednesday, January 13, 2010, 11:26:19 AM, you wrote:
MF I'm using SqLite. I tested the query with sqlite command line tool. The
MF query is correct. The problem is Zeos.
I had seen some references to that problem with Zeos and SQLite, but
not with other DB engines. So it
Ok. Thanks JoshyFun. I will report the bug to http://zeosbugs.firmos.at/
2010/1/13 JoshyFun joshy...@gmail.com
Hello Lazarus-List,
Wednesday, January 13, 2010, 11:26:19 AM, you wrote:
MF I'm using SqLite. I tested the query with sqlite command line tool. The
MF query is correct. The
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
Hello Lazarus-List,
Tuesday, January 12, 2010, 6:07:37 PM, you wrote:
MF I got an *sql logic error* trying to execute following query using Zeos
MF Component (ZQuery):
MF SELECT Invoices.*, Customers.Name
MF FROM Invoices
MF LEFT JOIN Customers
MF ON Invoices.CustomerID= Customers.ID
MF *
Thank you JoshyFun!
The problem remain. Now i can't apply any filter to Invoices fields! :(
For example this query raise an exception:
SELECT Invoices.*, Customers.Name
FROM Customers
RIGHT JOIN Invoices
ON Invoices.CustomerID= Customers.ID
* WHERE Invoices.Number 3*
2010/1/12 JoshyFun
On Tue, 12 Jan 2010 19:01:48 +0100, Massimo Fazzolari wrote about Re:
[Lazarus] Zeos Component Join Query:
The problem remain. Now i can't apply any filter to Invoices
fields! :(
For example this query raise an exception:
SELECT Invoices.*, Customers.Name
FROM Customers
RIGHT JOIN
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