Returns the values of the search result.

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 Array GetValues(
	IEnumerable<string> matchColumns,
	IEnumerable<Object> matchValues,
	IEnumerable<string> outColumns,
	bool distinct,
	IEnumerable<string> orderByColumns,
	out Array fieldsInfo
)
Visual Basic
Public Function GetValues ( _
	matchColumns As IEnumerable(Of String), _
	matchValues As IEnumerable(Of Object), _
	outColumns As IEnumerable(Of String), _
	distinct As Boolean, _
	orderByColumns As IEnumerable(Of String), _
	<OutAttribute> ByRef fieldsInfo As Array _
) As Array
Visual C++
public:
Array^ GetValues(
	IEnumerable<String^>^ matchColumns, 
	IEnumerable<Object^>^ matchValues, 
	IEnumerable<String^>^ outColumns, 
	bool distinct, 
	IEnumerable<String^>^ orderByColumns, 
	[OutAttribute] Array^% fieldsInfo
)

Parameters

matchColumns
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'String>)>)>
The collection of column names for which values will be searched 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.
outColumns
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'String>)>)>
The collection of column names for which to return values.
distinct
Type: System..::..Boolean
A value indicating whether to return only distinct values.
orderByColumns
Type: System.Collections.Generic..::..IEnumerable<(Of <(<'String>)>)>
The collection of column names that specifies the sorting order of returned values.
fieldsInfo
Type: System..::..Array%
A 2D array that contains the information about returned values (see ADO API http://msdn.microsoft.com/en-us/library/ms678086(VS.85).aspx).

Return Value

A 2D array of values ([column, row]) that represents the search result. If no results, an empty array.

Remarks

Executes a query like: SELECT outColumns[,...] FROM BaseQuery[ WHERE (matchColumns = matchValues[ AND ...])]

See Also