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 Update(
	string whereFilter,
	IEnumerable<Object> parameters,
	IEnumerable<string> setColumns,
	IEnumerable<Object> setValues
)
Visual Basic
Public Sub Update ( _
	whereFilter As String, _
	parameters As IEnumerable(Of Object), _
	setColumns As IEnumerable(Of String), _
	setValues As IEnumerable(Of Object) _
)
Visual C++
public:
void Update(
	String^ whereFilter, 
	IEnumerable<Object^>^ parameters, 
	IEnumerable<String^>^ setColumns, 
	IEnumerable<Object^>^ setValues
)

Parameters

whereFilter
Type: System..::..String
The search condition for the rows to delete. For example "(X = '1' AND Y = 3.14) OR Z = trueTruetruetrue (True in Visual Basic)".
parameters
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'Object>)>)>
The collection of parameters for the query (in the same order they appear in the SQL expression).
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 (whereFilter)]

See Also