Mimer SQL Data Provider help
ExecuteScalar Method




Mimer.Data.Client Namespace > MimerCommand Class : ExecuteScalar Method
Executes the query, and returns the first column of the first row in the result set returned by the query. Note that extra columns and/or rows are ignored.
Syntax
'Declaration
 
Public Overrides NotOverridable Function ExecuteScalar() As Object
public override object ExecuteScalar()
public function ExecuteScalar(): TObject; override; 
public override function ExecuteScalar() : Object;
public: Object* ExecuteScalar(); override 

Return Value

The first column of the first row in the result set. If the result set is empty, a null reference is returned.
Exceptions
ExceptionDescription
The Connection is not Open or statement is being used after Leave Retain.
A database server error occurred while executing the statement.
The data value of a parameter value was too large or too small to be converted to the database type.
The format of the value of one of the Parameters was invalid, or the application data type can not be converted to the target database type.
Requirements

.NET Framework
Version 2.0 or later

See Also

Reference

MimerCommand Class
MimerCommand Members