SQLSelect Properties |
The SQLSelect type exposes the following members.
Name | Description | |
---|---|---|
AppendData | ||
AppendFlag | **Missing documentation ** | |
BoF |
A logical value indicating whether the server is positioned at the beginning of the result set, on the first row.
(Overrides BoF.) | |
BoundedColumns | **Missing documentation ** | |
Clients | **Missing documentation ** (Inherited from DataServer.) | |
ConcurrencyControl |
A constant, identifying the mode of automatic concurrency control for this data server, determining when and how records are locked and released:
(Inherited from DataServer.) | |
Connection |
The SQL connection object that the SQLSelect is using to manipulate the result set.
| |
CursorName |
A string containing the cursor name.
| |
CursorType |
A constant, which describes the cursor type used by the SQL statement:
| |
DBStruct |
An array containing the structure of this data server.
(Overrides DBStruct.) | |
Deleted |
A logical value indicating whether the current row has been deleted.
| |
EoF |
A logical value indicating whether the server is positioned at the end of the result set, after the last row.
(Overrides EoF.) | |
ErrInfo |
An SQLErrorInformation object.
| |
FCount |
The number of columns in the result set. A value of -1 indicates an error.
(Overrides FCount.) | |
FOUND |
A logical value indicating whether the previous search operation succeeded.
| |
HLStatus | **Missing documentation ** (Inherited from DataServer.) | |
HyperLabel |
The hyperlabel connected to this data server. From the hyperlabel, you can retrieve additional information about the data server
(Inherited from DataServer.) | |
IndexColumns | ||
LASTREC | **Missing documentation ** | |
Modified | ||
MoreResults |
A logical value representing whether there are more rows to retrieve.
| |
Name |
A string representing the name of this data server.
(Inherited from DataServer.) | |
NameSym |
A symbol representing the name of this data server.
(Inherited from DataServer.) | |
NativeSQL |
A string containing the native SQL text of the statement.
Level 2
| |
NullAsBlank |
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value).
| |
NumCols | ||
NumParameters |
A numeric value containing the number of parameters. A value of -1 indicates an error.
Level 2
| |
NumResultColumns |
A numeric value containing the number of columns in the result set.
| |
NumSuccessfulRows |
A numeric value containing the number of rows that were modified by a delete, append, or update operation.
| |
PrepFlag |
A logical value that indicates if the select statement has been prepared.
| |
RecCount |
A numeric value representing the number of rows in the data server.
(Overrides RecCount.) | |
Recno |
A numeric value representing the relative position in the data server.
(Overrides RecNo.) | |
RecNo |
A numeric value representing the current record number, identifying the position of the record pointer in this data server.
(Inherited from DataServer.) | |
RowCount | ||
ScrollConcurrency |
A constant, which describes the concurrency mode used by the SQL statement:
| |
ScrollUpdateType |
A constant, which describes the type of SQL statement to use during append, update or delete operations.
| |
SimulateCursor |
A constant, which describes the way the ODBC drivers tries to guarantee that update or delete statements only affect one single row.
| |
SQLColumns | **Missing documentation ** | |
SqlData | **Missing documentation ** | |
SQLString |
A string representing the SQL statement text.
| |
Statement |
A SQL statement object.
| |
StatementHandle |
A numeric value representing the statement handle.
| |
Status |
A hyperlabel object identifying the status after the last operation.
(Overrides Status.) | |
TableName |
A string representing the name of the table.
| |
TimeStampAsDate | **Missing documentation ** | |
Used |
A logical value indicating whether the current query is active.
It returns TRUE if the current query is active; otherwise, it returns FALSE.
|