MATLAB: Does the UPDATE function in Database Toolbox 3.6 (R2009b) sometimes throw errors when used

Database Toolboxexecquerysqlsqlexecupdate

When using the UPDATE function in Database Toolbox 3.6 (R2009b), I receive the following error:
 ??? No constructor 'com.mathworks.toolbox.database.sqlExec' with matching signature
 found.
 Error in ==> cursor.cursor at 60
 curs.Cursor = com.mathworks.toolbox.database.sqlExec(curs.SQLQuery ,connect.Handle);
 Error in ==> database.exec at 34
     curs=cursor(connect,sqlQuery);
 Error in ==> database.update at 170
   cursTemp = exec(connect,writeString);
 60  curs.Cursor = com.mathworks.toolbox.database.sqlExec(curs.SQLQuery ,connect.Handle);
However, I am able to connect to database and insert rows without any issues.

Best Answer

In Database Toolbox 3.6 (R2009b) the UPDATE function invokes the EXEC function to execute a SQL query string.
The SQL query string must conform to the standard query string.
Typical errors would include
1. Table name mismatch. Cannot use any reserved keywords.
2. Column names mismatch
3. Data type mismatch (i.e. numeric, date, string)
4. SQL query string not having proper single quotes. Most Database toolbox functions require a string input argument for the SQL query string. If the SQL query also contains single quotes, additional single quotes are needed to allow MATLAB to parse the string.
Related Question