ExecuteScalar Method (query, depth)

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

Visual Basic

Visual C++

public Object ExecuteScalar(
	string query,
	int depth
)

Public Function ExecuteScalar ( _
	query As String, _
	depth As Integer _
) As Object

public:
Object^ ExecuteScalar(
	String^ query, 
	int depth
)

Parameters

query (String): Query to execute

depth (Int32): Activation depth of the object(s): value 0 means the shallow read.

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#

Book book = (Book)db.ExecuteScalar("SELECT Book WHERE title = @manual", 0);

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