Click or drag to resize

SQLSelect Properties (Typed)

X#

The SQLSelect type exposes the following members.

Properties
  NameDescription
Public propertyAppendData
Public propertyAppendFlag
**Missing documentation **
Public propertyBatchUpdates
Public propertyBoF
A logical value indicating whether the server is positioned at the beginning of the result set, on the first row.
(Overrides BoF.)
Public propertyClients
**Missing documentation **
(Inherited from DataServer.)
Public propertyConcurrencyControl
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.)
Public propertyConnection
The SQL connection object that the SQLSelect is using to manipulate the result set.
Public propertyCursorName
A string containing the cursor name.
Public propertyDBStruct
An array containing the structure of this data server.
(Overrides DBStruct.)
Public propertyDeleted
A logical value indicating whether the current row has been deleted.
Public propertyEoF
A logical value indicating whether the server is positioned at the end of the result set, after the last row.
(Overrides EoF.)
Public propertyErrInfo
An SQLErrorInformation object.
Public propertyFCount
The number of columns in the result set. A value of -1 indicates an error.
(Overrides FCount.)
Public propertyFOUND
A logical value indicating whether the previous search operation succeeded.
Public propertyHLStatus
**Missing documentation **
(Inherited from DataServer.)
Public propertyHyperLabel (Overrides HyperLabel.)
Public propertyIndexColumns
Public propertyLastRec (Overrides LastRec.)
Public propertylRowModified
Public propertyModified
Public propertyMoreResults
A logical value representing whether there are more rows to retrieve.
Public propertyName
A string representing the name of this data server.
(Inherited from DataServer.)
Public propertyNameSym
A symbol representing the name of this data server.
(Inherited from DataServer.)
Public propertyNativeSQL
A string containing the native SQL text of the statement. Level 2
Public propertyNullAsBlank
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value).
Public propertyNumCols
Public propertyNumParameters
A numeric value containing the number of parameters. A value of -1 indicates an error. Level 2
Public propertyNumResultColumns
A numeric value containing the number of columns in the result set.
Public propertyNumSuccessfulRows
A numeric value containing the number of rows that were modified by a delete, append, or update operation.
Public propertyPrepFlag
A logical value that indicates if the select statement has been prepared.
Public propertyReadOnly
Public propertyRecCount
A numeric value representing the number of rows in the data server.
(Overrides RecCount.)
Public propertyRecNo (Overrides RecNo.)
Public propertySQLColumns
**Missing documentation **
Public propertySqlData
**Missing documentation **
Public propertySQLString
A string representing the SQL statement text.
Public propertyStatement
A SQL statement object.
Public propertyStatementHandle
A numeric value representing the statement handle.
Public propertyCode exampleStatus
A hyperlabel object identifying the status after the last operation.
(Overrides Status.)
Public propertyTableName
A string representing the name of the table.
Public propertyTimeStampAsDate
**Missing documentation **
Public propertyUsed
A logical value indicating whether the current query is active. It returns TRUE if the current query is active; otherwise, it returns FALSE.
Top
See Also