SQL Error #42000 on MyDAC 4 - OK on MyDAC 3.55
Posted: Tue 02 Aug 2005 07:35
In version 4, I'm getting the following error when trying to set a filter programmatically (The filter works fine when set manually in Design mode):
The SQL statement is:
This works fine in 3.55. What am I missing here?
The filter-setting code is:#42000You have an error in your SQL syntax; check the manual that corresponds to you MySQL server version for the right syntax to use near 'WHERE varer.ID = 123' at line 1.
Code: Select all
DM.qryVarer.FilterSQL := 'varer.ID=123';
DM.qryVarer.Filtered := True;
DM.qryVarer.Active := True;Code: Select all
SELECT varer.*, artister.ARTIST, varegrupper.FARGE, varegrupper.MVARATE
FROM varer
LEFT OUTER JOIN artister ON (varer.ARTIST_ID=artister.ID)
LEFT OUTER JOIN varegrupper ON (varer.VAREGRUPPE_ID=varegrupper.ID)
ORDER BY artister.ARTIST, varer.TITTEL;
