Click or drag to resize

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
)

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