MyDAC 4 : Error when putting remarks on SQL statmenet

swierzbicki · Post by **swierzbicki** » Wed 31 Aug 2005 14:06

Hi Ikar,

I'm getting an error when opening this query :

SELECT
*
FROM
configurationgrilles
--WHERE (FormName = :FormName) and (GridName = :GridName)

It looks like the parser doesn't treat -- as remarks

Ikar · Post by **Ikar** » Wed 31 Aug 2005 14:35

This is MySQL server limitation. Please see details in http://dev.mysql.com/doc/mysql/en/ansi- ... ments.html

GEswin · Post by **GEswin** » Wed 31 Aug 2005 16:46

--WHERE (FormName = :For....

Put a space between the -- and the WHERE

swierzbicki · Post by **swierzbicki** » Thu 01 Sep 2005 06:22

Didn't noticed that was so easy to "fix"
Thank you