Click or drag to resize
BCSQuerySelect Method (String, String, String, String, String)
Returns the values of the search result.

Namespace: BlueCieloECM.InnoCielo.Meridian.Scripting
Assembly: BlueCieloECM.InnoCielo.Meridian (in BlueCieloECM.InnoCielo.Meridian.dll) Version: 4.0.0.0 (4.0.19.0)
Syntax
public Array Select(
	string selectList,
	string whereFilter,
	string groupBy,
	string having,
	string orderBy
)

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

Return Value

Type: Array
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 (whereFilter)]. More info: - Transact-SQL Reference (Transact-SQL) http://msdn.microsoft.com/en-us/library/ms189826(SQL.90).aspx
See Also