BCSQuerySelect Method (String, String, String, String, String, IEnumerableObject, Array) |
Returns the values of the search result.
Namespace: BlueCieloECM.InnoCielo.Meridian.ScriptingAssembly: 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,
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
public:
Array^ Select(
String^ selectList,
String^ whereFilter,
String^ groupBy,
String^ having,
String^ orderBy,
IEnumerable<Object^>^ parameters,
[OutAttribute] Array^% fieldsInfo
)
member Select :
selectList : string *
whereFilter : string *
groupBy : string *
having : string *
orderBy : string *
parameters : IEnumerable<Object> *
fieldsInfo : Array byref -> 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
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 Base Query[ WHERE (whereFilter)].
More info:
- Transact-SQL Reference (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms189826(SQL.90).aspx
See Also