Updates values in the table.

Namespace: BlueCieloECM.InnoCielo.Meridian.Scripting
Assembly: BlueCieloECM.InnoCielo.Meridian (in BlueCieloECM.InnoCielo.Meridian.dll) Version: 1.4.0.0 (1.4.40.0)

Syntax

C#
public void UpdateValues(
	IEnumerable<string> matchColumns,
	IEnumerable<Object> matchValues,
	IEnumerable<string> setColumns,
	IEnumerable<Object> setValues
)
Visual Basic
Public Sub UpdateValues ( _
	matchColumns As IEnumerable(Of String), _
	matchValues As IEnumerable(Of Object), _
	setColumns As IEnumerable(Of String), _
	setValues As IEnumerable(Of Object) _
)
Visual C++
public:
void UpdateValues(
	IEnumerable<String^>^ matchColumns, 
	IEnumerable<Object^>^ matchValues, 
	IEnumerable<String^>^ setColumns, 
	IEnumerable<Object^>^ setValues
)

Parameters

matchColumns
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'String>)>)>
The collection of column names of which to search the value for a match.
matchValues
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'Object>)>)>
The collection of field values to match. The collection size must be the same as the matchColumns collection size.
setColumns
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'String>)>)>
The collection of column names to update.
setValues
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'Object>)>)>
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