MyDAC 4 : Error when putting remarks on SQL statmenet

MyDAC 4 : Error when putting remarks on SQL statmenet

Postby 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
swierzbicki
 
Posts: 451
Joined: Wed 19 Jan 2005 09:59

Postby 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
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby GEswin » Wed 31 Aug 2005 16:46

Code: Select all
--WHERE (FormName = :For....


Put a space between the -- and the WHERE ;)
GEswin
 
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain

Postby swierzbicki » Thu 01 Sep 2005 06:22

Didn't noticed that was so easy to "fix"
Thank you ;)
swierzbicki
 
Posts: 451
Joined: Wed 19 Jan 2005 09:59


Return to MySQL Data Access Components