Devart Forums

Posted: **Sat 10 Sep 2011 03:41**

#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[$TABLENAME] set [$MODIFIED$FIELDS] where [$PRIMARYFIELDS]' at line 1.

what does that Error meen?

using delphi2007, unidac 3.70.0.19, mysqlserver 5.5.15, windows 7 pro

Kind regards
Vallemanden

Posted: **Mon 12 Sep 2011 12:17**

Hello,

This error means that you have a syntax error in your SQL code. Please specify the exact SQL code you are trying to execute. This is an example of the correct update SQL code for MySQL server:

Code: Select all

UPDATE TABLENAME SET FIELDNAME=FIELDVALUE WHERE PK_FIELD=PK_FIELDVALUE

Posted: **Tue 13 Sep 2011 07:32**

i just start now to delete the component, and put it back on, then everything looks fine.
so my sql is ok

Posted: **Tue 13 Sep 2011 10:59**

It is good to see that this problem was solved. Feel free to contact us if you have any further questions about UniDAC.

Devart Forums

error #42000

error #42000