SQLSelect Properties (Typed) |
The SQLSelect type exposes the following members.
Name | Description | |
---|---|---|
AppendData | ||
AppendFlag | **Missing documentation ** | |
BatchUpdates | ||
BoF |
A logical value indicating whether the server is positioned at the beginning of the result set, on the first row.
(Overrides BoF.) | |
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.
| |
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 | (Overrides HyperLabel.) | |
IndexColumns | ||
LastRec | (Overrides LastRec.) | |
lRowModified | ||
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.
| |
ReadOnly | ||
RecCount |
A numeric value representing the number of rows in the data server.
(Overrides RecCount.) | |
RecNo | (Overrides RecNo.) | |
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.
|