Updates values in the current Table object.
Syntax
UpdateValuesEx(Where As String, Parameters, SetColumns, SetValues)
| Name | Description |
|---|---|
|
Where |
Condition for matching column values to update in the current table. |
|
Parameters |
String or array of strings of values to be used in a parameterized query. The array should contain a value for each instance of the ? character in the SQL query. |
|
SetColumns |
Array of column names to set in the table. |
|
SetValues |
Array of column values to set in the table. |
Remarks
The UpdateValuesEx method is functionally equivalent to UpdateValues. However, the UpdateValuesEx method supports parameters in the same order as a standard SQL query. This may be more convenient to use than UpdateValues if you are already familiar with the SQL language.
Related concepts