Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADCustomConnection.ExecSQLScalar Method (String)
TADCustomConnection Class  TADCustomConnection Members  uADCompClient Namespace  Example  public  See Also  Send Feedback

Executes a SQL command without parameters and fetches a single value.

Group

public

Links
TADCustomConnection Class, TADCustomConnection Members, uADCompClient Namespace, Example, public, See Also
Parameters
Parameters 
Description 
const ASQL: String 
A SQL command to execute. 
Returns

The value of first column in first row of first result set.

Description

The ExecSQLScalar method executes a SQL command without parameters. The method returns a value of first column in first row of first result set. All other cursors will be discarded.

Syntax
function ExecSQLScalar(const ASQL: String): Variant; overload;
See Also
Example
var
  sVersion: String;
...
  sVersion := ADConnection1.ExecSQLScalar('select @@version');
What do you think about this topic? Send feedback!