Eloquera Database
ExecuteScalar Method (query, depth, parameters)
NamespacesEloquera.ClientDBExecuteScalar(String, Int32, Parameters)
Returns first object from the query result. Data is retrieved by executing SQL statements. For information on the SQL syntax supported, see the SQL document "Eloquera SQL Reference", Throws an exception if the SQL statement fails to execute.
Declaration Syntax
C#Visual BasicVisual C++
public Object ExecuteScalar(
	string query,
	int depth,
	Parameters parameters
)
Public Function ExecuteScalar ( _
	query As String, _
	depth As Integer, _
	parameters As Parameters _
) As Object
public:
Object^ ExecuteScalar(
	String^ query, 
	int depth, 
	Parameters^ parameters
)
Parameters
query (String)
Query to execute
depth (Int32)
Activation depth of the object(s): value 0 means shallow read
parameters (Parameters)
Parameters for the query
Return Value
The object corresponding to the requested query.
Remarks
If the query returns multiple objects, only the first one will be returned. If the query results in the empty set, null is returned.
Examples
CopyC#
Parameters param = db.CreateParameters();
param["manual"] = "Operation Manual";
Book book = (Book)db.ExecuteScalar("SELECT Book WHERE title = @manual", 0, param);

Assembly: Eloquera.Client (Module: Eloquera.Client) Version: 4.5.0.0 (4.5.0.0)