SQL Error #42000 on MyDAC 4 - OK on MyDAC 3.55

[TomS]

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):

#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.

The filter-setting code is:

Code: Select all

DM.qryVarer.FilterSQL := 'varer.ID=123';
DM.qryVarer.Filtered := True;
DM.qryVarer.Active := True;

The SQL statement is:

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;

This works fine in 3.55. What am I missing here?

[Hans]

I don't think you are missing anything.
It looks as if the sortclausule is put prior to the whereclausule, which leads to errors.

[Ikar]

Fixed. We will try to make this fix available at current week.

[TomS]

Thanks for your prompt reply. I'll stand by for the fix...

Tom

[el_ade]

I have the same problem, I have purchaded the mydac 4.0 and on recompiling of my application occurs the same problem.

Isn´t still available the fix?

[Ikar]

New build was released and you can download it (4.00.0.2) now from Core Lab server.
Please see details http://crlab.com/forums/viewtopic.php?t=1724

[TomS]

Lookin' good, guys. Lookin' REAL good.

Thanks.