Updates values in the current Table object.
Syntax
UpdateValues(MatchColumns, MatchValues, SetColumns, SetValues)
| Name | Description |
|---|---|
|
MatchColumns |
Array of matching column names to update in the current table. |
|
MatchValues |
Array of matching column values to update in the current table. |
|
SetColumns |
Array of column names to set in the current table. |
|
SetValues |
Array of column values to set in the current table. |
Remarks
The UpdateValues method executes an SQL query with the specified parameters. For example, the following VBScript statement:
Vault.Table("Employees").UpdateValues(Array("FirstName","LastName"), Array("John","Smith"), Array(“Role”, “Department”), Array(“Manager”, “Engineering”))
translates into the following SQL query:
UPDATE Employees SET Role='Manager' AND Department=’Engineering’ WHERE FirstName=’John’, LastName=’Smith’
Related concepts