RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TAdoDbxCommand.ExecuteScalar Method
TAdoDbxCommand Class | TAdoDbxCommand Members | Borland.Data.AdoDbxClientProvider Namespace | Description | See Also
Collapse All

Execute a SQL query and return the first column of the first row of data.

Pascal
function ExecuteScalar: System; override;
C++
virtual __fastcall System ExecuteScalar();
Description

ExecuteScalar returns only the first column of the first row of data from a SQL query.

Note: ExecuteScalar is useful for running aggregate SQL commands, such as select sum(field) from table.
 

See Also
Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!