BCSQuerySelect Method (String, String, String, String, String, IEnumerableObject, Array)

public Array Select(
	string selectList,
	string whereFilter,
	string groupBy,
	string having,
	string orderBy,
	IEnumerable<Object> parameters,
	out Array fieldsInfo
)

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

Parameters

selectList

Type: SystemString
The collection of column names for which to return values. [ALL | DISTINCT][ TOP n [PERCENT ][WITH TIES]][ column_list[, ...] | *]

whereFilter

Type: SystemString
The search condition for the rows returned by the query. For example "(X = '1' AND Y = 3.14) OR Z = ".

groupBy

Type: SystemString
Specifies the groups into which output values are to be placed (see SQL reference).

having

Type: SystemString
Specifies an additional filtering condition on the result of a grouping (see SQL reference).

orderBy

Type: SystemString
Specifies the ordering of the resulting values (see SQL reference).

parameters

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

fieldsInfo

Type: SystemArray
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

Reference