update value in an sql database using 'update' function

When I try to use 'update' to change a value in an sql database,

I'm getting this error:

Incorrect number or types of inputs or outputs for function 'update'.

Error in TestFile (line 26)

update(conn,tablename,colnames,data,whereclause)

Here is my code:

conn = postgresql('MyDataBase','','');

tablename = 'lot_numbers'

colnames = 'active_lot'

data = false

whereclause = 'WHERE sub_lot_number = ''1322-test'''

update(conn,tablename,colnames,data,whereclause)

My version of the database toolbox is 10.4

Answer 1

[Sachin]

Hi @Rusul Altaay,

Since you are receiving this error ‘incorrect number or types of inputs or outputs for function ‘update’’. It may be because of an incorrect input format.

Your inputs to the function ‘update’ must be in the correct formats.

e.g. – ‘whereclause’ specified as a character vector or string scalar for one condition.

Refer to the following page for more information about ‘update’ function inputs and their formats.

https://www.mathworks.com/help/database/ug/database.odbc.connection.update.html