error #42000

vallemanden · Post by **vallemanden** » 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

AndreyZ · Post by **AndreyZ** » 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

vallemanden · Post by **vallemanden** » 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

AndreyZ · Post by **AndreyZ** » 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.