Lazarus and Zeos Master/Detail error
Posted: 09.12.2007, 18:54
Hi !
In Lazarus 0.92.24 and Zeos 315 Testing the master/detail faild on opening
the detail dataset.
I have on form 2 ZQuery, first is master and another is slave (detail),
with properly connected trought masters datasource. Required fields is exists in both datasets !
Here is the SQL monitor generated file of wath is hapening :
2007-12-09 18:02:46 cat: Execute, proto: mysql-5, msg: SHOW TABLES FROM kugel_07 LIKE 'sifarnik'
2007-12-09 18:02:46 cat: Execute, proto: mysql-5, msg: SHOW COLUMNS FROM kugel_07.sifarnik LIKE '%'
2007-12-09 18:02:56 cat: Execute, proto: mysql-5, msg: SELECT * FROM prometz
WHERE tip = "OTP" AND dok = 1
ORDER BY tip, dok
2007-12-09 18:02:56 cat: Execute, proto: mysql-5, msg: SHOW TABLES FROM kugel_07 LIKE 'prometz'
2007-12-09 18:02:56 cat: Execute, proto: mysql-5, msg: SHOW COLUMNS FROM kugel_07.prometz LIKE '%'
2007-12-09 18:02:56 cat: Execute, proto: mysql-5, msg: SELECT * FROM promet
WHERE tip = :tip AND dok = :dok
ORDER BY tip, dok
, errcode: 1064, error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':tip AND dok = :dok
ORDER BY tip, dok' at line 2
It is a bug or I hawe to do something different to get correct result ?
Thanks.
In Lazarus 0.92.24 and Zeos 315 Testing the master/detail faild on opening
the detail dataset.
I have on form 2 ZQuery, first is master and another is slave (detail),
with properly connected trought masters datasource. Required fields is exists in both datasets !
Here is the SQL monitor generated file of wath is hapening :
2007-12-09 18:02:46 cat: Execute, proto: mysql-5, msg: SHOW TABLES FROM kugel_07 LIKE 'sifarnik'
2007-12-09 18:02:46 cat: Execute, proto: mysql-5, msg: SHOW COLUMNS FROM kugel_07.sifarnik LIKE '%'
2007-12-09 18:02:56 cat: Execute, proto: mysql-5, msg: SELECT * FROM prometz
WHERE tip = "OTP" AND dok = 1
ORDER BY tip, dok
2007-12-09 18:02:56 cat: Execute, proto: mysql-5, msg: SHOW TABLES FROM kugel_07 LIKE 'prometz'
2007-12-09 18:02:56 cat: Execute, proto: mysql-5, msg: SHOW COLUMNS FROM kugel_07.prometz LIKE '%'
2007-12-09 18:02:56 cat: Execute, proto: mysql-5, msg: SELECT * FROM promet
WHERE tip = :tip AND dok = :dok
ORDER BY tip, dok
, errcode: 1064, error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':tip AND dok = :dok
ORDER BY tip, dok' at line 2
It is a bug or I hawe to do something different to get correct result ?
Thanks.