You have an error in your SQL syntax.
---------------------------
ZenIT
---------------------------
[MySQL][ODBC 3.51 Driver][mysqld-4.0.13]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BAD"',0)' at line 1
Error in cmdOK_Click
---------------------------
OK
---------------------------
Solution:
Please note that this error normally occurs when you have used some Special Character in the client master’s address details or in Ward detail.
To resolve the error, we suggest that you please Edit the Client Master of the particular client in which this error is occurring and remove such special symbols like comma, Apostrophe, inverted comma etc. and update the details.
Now, try to generate the computation.
This should resolve the error.
Related Articles
[MYSQL][odbc 3.51 Driver]Access denied for user 'root'@'localhost' (using password: NO)
[MYSQL][odbc 3.51 Driver]Access denied for user 'root'@'localhost' (using password: NO) [MYSQL][odbc 3.51 Driver]{mysqld-5.5.5-10.4.10-mariaDB}you have an error in your sql syntax; check the manual that corresponds to your MariaDB server ...[MYSQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'LOCALHOST' (10061)
MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. KDK Software uses MySQL as its ...Error 127 Table Handler - [MYSQL][ODBC 3.51 Driver ]mysqld -4.0.13
If there is any sort of malfunctioning in executing the software and due to any reason if the software gets automatically closed /shutdown, the user would encounter the error 127. Solution: Please follow the below troubleshoot (on server ...Error in income tax Auditor > Run time error 339
Error in income tax Auditor > Run time error 339 Component 'KDKClient.ocx' or one of its dependencies not correctly registered: a file is missing or invalid. Solution: Step 1. To resolve the error, Go to Root location of the ...SQL SERVER Installation error > Consistency Validation For SQL Server Registry Keys
You are attempting to install the SQL Server 2008 R2 when you receive the following error message: "Consistency validation for SQL Server registry keys failed." NOTE: This issue can occur if an existing key for Microsoft® Business Contact Manager in ...