BCUserDBExecSQL Method (String, IEnumerableObject, Array) |
Executes an SQL query against the user database.
Namespace:
BlueCieloECM.InnoCielo.Meridian.Server
Assembly:
BlueCieloECM.InnoCielo.Meridian (in BlueCieloECM.InnoCielo.Meridian.dll) Version: 4.0.0.0 (4.0.111.0)
Syntax public Array ExecSQL(
string query,
IEnumerable<Object> parameters,
out Array fieldsInfo
)
Public Function ExecSQL (
query As String,
parameters As IEnumerable(Of Object),
<OutAttribute> ByRef fieldsInfo As Array
) As Array
Parameters
- query
- Type: SystemString
The SQL query to execute.
- parameters
- Type: System.Collections.GenericIEnumerableObject
The collection of parameters for the query (in the same order they appear in 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 sql result.
If no result, an empty array.
See Also