BCSQuerySelect Method (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.111.0)
Syntax public Array Select(
string selectList,
string whereFilter
)
Public Function Select (
selectList As String,
whereFilter As String
) 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 = ".
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