Page 1 of 1

MyDAC 4 : Error when putting remarks on SQL statmenet

Posted: Wed 31 Aug 2005 14:06
by swierzbicki
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

Posted: Wed 31 Aug 2005 14:35
by Ikar
This is MySQL server limitation. Please see details in http://dev.mysql.com/doc/mysql/en/ansi- ... ments.html

Posted: Wed 31 Aug 2005 16:46
by GEswin

Code: Select all

--WHERE (FormName = :For....
Put a space between the -- and the WHERE ;)

Posted: Thu 01 Sep 2005 06:22
by swierzbicki
Didn't noticed that was so easy to "fix"
Thank you ;)