MyDAC 4 : Error when putting remarks on SQL statmenet

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
swierzbicki
Posts: 451
Joined: Wed 19 Jan 2005 09:59

MyDAC 4 : Error when putting remarks on SQL statmenet

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

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
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain
Contact:

Post by GEswin » Wed 31 Aug 2005 16:46

Code: Select all

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

swierzbicki
Posts: 451
Joined: Wed 19 Jan 2005 09:59

Post by swierzbicki » Thu 01 Sep 2005 06:22

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

Post Reply