Update Method (String, IEnumerable(Object), IEnumerable(String), IEnumerable(Object))

BCSTable Update Method (String, IEnumerable Object , IEnumerable String , IEnumerable Object )

Meridian Enterprise 2013 Developer's Guide | BlueCielo ECM Solutions

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.53.0)

Syntax

C++

Copy to Clipboard Print

public void Update(
	string whereFilter,
	IEnumerable<Object> parameters,
	IEnumerable<string> setColumns,
	IEnumerable<Object> setValues
)

public void Update(
	string whereFilter,
	IEnumerable<Object> parameters,
	IEnumerable<string> setColumns,
	IEnumerable<Object> setValues
)

Public Sub Update ( _
	whereFilter As String, _
	parameters As IEnumerable(Of Object), _
	setColumns As IEnumerable(Of String), _
	setValues As IEnumerable(Of Object) _
)

Public Sub Update ( _
	whereFilter As String, _
	parameters As IEnumerable(Of Object), _
	setColumns As IEnumerable(Of String), _
	setValues As IEnumerable(Of Object) _
)

public:
void Update(
	String^ whereFilter, 
	IEnumerable<Object^>^ parameters, 
	IEnumerable<String^>^ setColumns, 
	IEnumerable<Object^>^ setValues
)

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 = ".

parameters: Type: System.Collections.Generic IEnumerable Object
The collection of parameters for the query (in the same order they appear in the SQL expression).

setColumns: Type: System.Collections.Generic IEnumerable String
The collection of column names to update.

setValues: Type: System.Collections.Generic IEnumerable 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)]