UpdateValues Method (IEnumerable(String), IEnumerable(Object), IEnumerable(String), IEnumerable(Object))

BCSTable UpdateValues Method (IEnumerable 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 UpdateValues(
	IEnumerable<string> matchColumns,
	IEnumerable<Object> matchValues,
	IEnumerable<string> setColumns,
	IEnumerable<Object> setValues
)

public void UpdateValues(
	IEnumerable<string> matchColumns,
	IEnumerable<Object> matchValues,
	IEnumerable<string> setColumns,
	IEnumerable<Object> setValues
)

Public Sub UpdateValues ( _
	matchColumns As IEnumerable(Of String), _
	matchValues As IEnumerable(Of Object), _
	setColumns As IEnumerable(Of String), _
	setValues As IEnumerable(Of Object) _
)

Public Sub UpdateValues ( _
	matchColumns As IEnumerable(Of String), _
	matchValues As IEnumerable(Of Object), _
	setColumns As IEnumerable(Of String), _
	setValues As IEnumerable(Of Object) _
)

public:
void UpdateValues(
	IEnumerable<String^>^ matchColumns, 
	IEnumerable<Object^>^ matchValues, 
	IEnumerable<String^>^ setColumns, 
	IEnumerable<Object^>^ setValues
)

public:
void UpdateValues(
	IEnumerable<String^>^ matchColumns, 
	IEnumerable<Object^>^ matchValues, 
	IEnumerable<String^>^ setColumns, 
	IEnumerable<Object^>^ setValues
)

Parameters

matchColumns: Type: System.Collections.Generic IEnumerable String
The collection of column names of which to search the value for a match.

matchValues: Type: System.Collections.Generic IEnumerable 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 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 (MatchColumns = MatchValues[ AND ...])]