update value in an sql database using 'update' function

6 次查看(过去 30 天)
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

回答(1 个)

Sachin
Sachin 2023-3-17
编辑:Sachin 2023-3-17
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.

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

产品


版本

R2022b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by