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,
	string setColumn,
	Object setValue
)
Visual Basic
Public Sub UpdateValues ( _
	matchColumns As IEnumerable(Of String), _
	matchValues As IEnumerable(Of Object), _
	setColumn As String, _
	setValue As Object _
)
Visual C++
public:
void UpdateValues(
	IEnumerable<String^>^ matchColumns, 
	IEnumerable<Object^>^ matchValues, 
	String^ setColumn, 
	Object^ setValue
)

Parameters

matchColumns
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'String>)>)>
The collection of column names of which to search the values 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.
setColumn
Type: System..::..String
The column name to update.
setValue
Type: System..::..Object
The column value.

Remarks

Executes a query like: UPDATE TableName SET setColumn = 'setValue' [ WHERE (MatchColumns = MatchValues[ AND ...])]

See Also