SQLSelect Properties |  |
The SQLSelect type exposes the following members.
Properties| 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.
|
See Also