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
0 个评论
回答(1 个)
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.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!