SQLCatalogQuery Properties (Typed) |
The SQLCatalogQuery type exposes the following members.
Name | Description | |
---|---|---|
AppendData | (Inherited from SQLSelect.) | |
AppendFlag | **Missing documentation ** (Inherited from SQLSelect.) | |
BatchUpdates | (Inherited from SQLSelect.) | |
BoF |
A logical value indicating whether the server is positioned at the beginning of the result set, on the first row.
(Inherited from SQLSelect.) | |
Clients | **Missing documentation ** (Inherited from DataServer.) | |
Collection | ||
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.
(Inherited from SQLSelect.) | |
CursorName |
A string containing the cursor name.
(Inherited from SQLSelect.) | |
DBStruct |
An array containing the structure of this data server.
(Inherited from SQLSelect.) | |
Deleted |
A logical value indicating whether the current row has been deleted.
(Inherited from SQLSelect.) | |
EoF |
A logical value indicating whether the server is positioned at the end of the result set, after the last row.
(Inherited from SQLSelect.) | |
ErrInfo |
An SQLErrorInformation object.
(Inherited from SQLSelect.) | |
FCount |
The number of columns in the result set. A value of -1 indicates an error.
(Inherited from SQLSelect.) | |
FOUND |
A logical value indicating whether the previous search operation succeeded.
(Inherited from SQLSelect.) | |
HLStatus | **Missing documentation ** (Inherited from DataServer.) | |
HyperLabel | (Inherited from SQLSelect.) | |
IndexColumns | (Inherited from SQLSelect.) | |
LastRec | (Inherited from SQLSelect.) | |
lRowModified | (Inherited from SQLSelect.) | |
Modified | (Inherited from SQLSelect.) | |
MoreResults |
A logical value representing whether there are more rows to retrieve.
(Inherited from SQLSelect.) | |
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
(Inherited from SQLSelect.) | |
NullAsBlank |
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value).
(Inherited from SQLSelect.) | |
NumCols | (Inherited from SQLSelect.) | |
NumParameters |
A numeric value containing the number of parameters. A value of -1 indicates an error.
Level 2
(Inherited from SQLSelect.) | |
NumResultColumns |
A numeric value containing the number of columns in the result set.
(Inherited from SQLSelect.) | |
NumSuccessfulRows |
A numeric value containing the number of rows that were modified by a delete, append, or update operation.
(Inherited from SQLSelect.) | |
PrepFlag |
A logical value that indicates if the select statement has been prepared.
(Inherited from SQLSelect.) | |
ReadOnly | (Inherited from SQLSelect.) | |
RecCount |
A numeric value representing the number of rows in the data server.
(Inherited from SQLSelect.) | |
RecNo | (Inherited from SQLSelect.) | |
SQLColumns | **Missing documentation ** (Inherited from SQLSelect.) | |
SqlData | **Missing documentation ** (Inherited from SQLSelect.) | |
SQLString |
A string representing the SQL statement text.
(Inherited from SQLSelect.) | |
Statement |
A SQL statement object.
(Inherited from SQLSelect.) | |
StatementHandle |
A numeric value representing the statement handle.
(Inherited from SQLSelect.) | |
Status |
A hyperlabel object identifying the status after the last operation.
(Inherited from SQLSelect.) | |
TableName |
A string representing the name of the table.
(Inherited from SQLSelect.) | |
TimeStampAsDate | **Missing documentation ** (Inherited from SQLSelect.) | |
Used |
A logical value indicating whether the current query is active.
It returns TRUE if the current query is active; otherwise, it returns FALSE.
(Inherited from SQLSelect.) |