Click or drag to resize

BCSTableUpdateValues Method (IEnumerableString, IEnumerableObject, IEnumerableString, IEnumerableObject)

Updates values in the table.

Namespace:  BlueCieloECM.InnoCielo.Meridian.Scripting
Assembly:  BlueCieloECM.InnoCielo.Meridian (in BlueCieloECM.InnoCielo.Meridian.dll) Version: 4.0.0.0 (4.0.111.0)
Syntax
public void UpdateValues(
	IEnumerable<string> matchColumns,
	IEnumerable<Object> matchValues,
	IEnumerable<string> setColumns,
	IEnumerable<Object> setValues
)

Parameters

matchColumns
Type: System.Collections.GenericIEnumerableString
The collection of column names of which to search the value for a match.
matchValues
Type: System.Collections.GenericIEnumerableObject
The collection of field values to match. The collection size must be the same as the matchColumns collection size.
setColumns
Type: System.Collections.GenericIEnumerableString
The collection of column names to update.
setValues
Type: System.Collections.GenericIEnumerableObject
The collection of field values. The collection size must be the same as the setColumns collection size.
Remarks
Executes a query like: UPDATE TableName SET setColumns = 'setValues'[,...])[ WHERE (MatchColumns = MatchValues[ AND ...])]
See Also