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 Select(
	string selectList,
	string whereFilter,
	string groupBy,
	string having,
	string orderBy,
	IEnumerable<Object> parameters,
	out Array fieldsInfo
)
Visual Basic
Public Function Select ( _
	selectList As String, _
	whereFilter As String, _
	groupBy As String, _
	having As String, _
	orderBy As String, _
	parameters As IEnumerable(Of Object), _
	<OutAttribute> ByRef fieldsInfo As Array _
) As Array
Visual C++
public:
Array^ Select(
	String^ selectList, 
	String^ whereFilter, 
	String^ groupBy, 
	String^ having, 
	String^ orderBy, 
	IEnumerable<Object^>^ parameters, 
	[OutAttribute] Array^% fieldsInfo
)

Parameters

selectList
Type: System..::..String
The collection of column names for which to return values. [ALL | DISTINCT][ TOP n [PERCENT ][WITH TIES]][ column_list[, ...] | *]
whereFilter
Type: System..::..String
The search condition for the rows returned by the query. For example "(X = '1' AND Y = 3.14) OR Z = trueTruetruetrue (True in Visual Basic)".
groupBy
Type: System..::..String
Specifies the groups into which output values are to be placed (see SQL reference).
having
Type: System..::..String
Specifies an additional filtering condition on the result of a grouping (see SQL reference).
orderBy
Type: System..::..String
Specifies the ordering of the resulting values (see SQL reference).
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).
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 Base Query[ WHERE (whereFilter)]. More info: - Transact-SQL Reference (Transact-SQL) http://msdn.microsoft.com/en-us/library/ms189826(SQL.90).aspx

See Also