User`s guide

update
7-249
data — Update data
cell array | numeric matrix | structure
Update data, specified as a MATLAB variable with cell array, numeric matrix, or
structure format. If data is a structure, field names in the structure must match field
names in colnames.
Data Types: double | struct | cell
whereclause — SQL WHERE clause
string | cell array
SQL WHERE clause, specified as a string for one condition or a cell array of strings for
multiple conditions.
Example: 'WHERE productTable.productNumber = 1'
Data Types: char
More About
Tips
• The status of the AutoCommit flag determines whether update automatically
commits the data to the database. View the AutoCommit flag status for the
connection using get and change it using set. Commit the data by running commit
or an SQL commit statement using the exec function. Roll back the data by running
rollback or an SQL rollback statement using the exec function.
• To add new rows instead of replacing existing data, use fastinsert.
• To update multiple records, the number of SQL WHERE clauses in whereclause
must match the number of records in data.
• The order of records in your database is not constant. Use values of column names to
identify records.
• This error message can appear when your database table is open in edit mode.
[Vendor][ODBC Product Driver] The database engine could
not lock table 'TableName' because it is already in use
by another person or process.
In this case, close the table and rerun the update function.