SetValue
Updates multiple keysets in group GroupName by setting the key KeyName to Value for all keysets that match Condition. The condition is specified using basic SQL WHERE syntax. The Condition may be left empty in which case all keysets in GroupName are updated. Note that KeyName must exist in GroupName, otherwise an error is raised. The method returns an array of the keyset ID's that were updated ( [1,2] ), or an empty array ( [] ) if no keysets were updated.
There is currently no Update feature in the API for a whole KeySet (a row).
Syntax
SetValue(GroupName: string, KeyName: string, Value: string, Condition: string): string
Examples
In each of these examples, the object repoObject
is deemed having been obtained through a call to the COM object "RepositoryLib.WorkflowRepository" (see Obtaining an instance of the Repository Object).
JavaScript
repoObject.SetValue("Users", "FormOfAddress", "Mr.", "Gender='M'" );
repoObject.SetValue("Users", "FormOfAddress", "Ms.", "Gender='F' AND MaritalStatus='Married'" );
repoObject.SetValue("Users", "FormOfAddress", "Miss", "Gender='F' AND MaritalStatus=''" );
VB Script
repoObject.SetValue "Users", "FormOfAddress", "Mr.", " Gender=""M"" "
repoObject.SetValue "Users", "FormOfAddress", "Ms.", " Gender=""F"" AND MaritalStatus=""Married"" "
repoObject.SetValue "Users", "FormOfAddress", "Miss", " Gender=""F"" AND MaritalStatus="""" "