Income Tax || You have an error in your SQL syntax

Income Tax || You have an error in your SQL syntax

[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

            

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

    • You have an error in your SQL Syntax while software opening

      Issue → An SQL syntax error appears when attempting to open the software. Root Cause → This issue typically occurs due to corruption in the it_tbl115bac and tbllogfile tables within the current database. Solution → To resolve this error, please ...

    • 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 back-end ...

    • 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 system of ...

    • ODBC error while importing data from Tally software

      Software provides an option to import data directly from Tally to IT Auditor Software. Below error message appears when user tries to import trial balance from Tally.ERP 9 to Income Tax Auditor Software. This happens when ODBC and Tally.ERP 9 are not ...

    • 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 version for the right syntax to user near 'TYPE-MyISAM' at line 1 Cause : This error mainly occurs ...