ExecSQL Method (String, IEnumerable(Object), Array)

BCUserDB ExecSQL Method (String, IEnumerable Object , Array )

Meridian Enterprise 2013 Developer's Guide | BlueCielo ECM Solutions

Executes an SQL query against the user database.

Namespace: BlueCieloECM.InnoCielo.Meridian.Server
Assembly: BlueCieloECM.InnoCielo.Meridian (in BlueCieloECM.InnoCielo.Meridian.dll) Version: 1.4.0.0 (1.4.53.0)

Syntax

C++

Copy to Clipboard Print

public Array ExecSQL(
	string query,
	IEnumerable<Object> parameters,
	out Array fieldsInfo
)

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

Public Function ExecSQL ( _
	query As String, _
	parameters As IEnumerable(Of Object), _
	<OutAttribute> ByRef fieldsInfo As Array _
) As Array

public:
Array^ ExecSQL(
	String^ query, 
	IEnumerable<Object^>^ parameters, 
	[OutAttribute] Array^% fieldsInfo
)

public:
Array^ ExecSQL(
	String^ query, 
	IEnumerable<Object^>^ parameters, 
	[OutAttribute] Array^% fieldsInfo
)

Parameters

query: Type: System String
The SQL query to execute.

parameters: Type: System.Collections.Generic IEnumerable Object
The collection of parameters for the query (in the same order they appear in SQL expression).

fieldsInfo: Type: System Array
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

A 2D array of values ([column, row]) that represents the sql result. If no result, an empty array.