Click or drag to resize

SQLSelect Properties

X#

The SQLSelect type exposes the following members.

Properties
  NameDescription
Public propertyAppendData
Public propertyAppendFlag
**Missing documentation **
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 propertyBoundedColumns
**Missing documentation **
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 propertyCursorType
A constant, which describes the cursor type used by the SQL statement:
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 propertyCode exampleHyperLabel
The hyperlabel connected to this data server. From the hyperlabel, you can retrieve additional information about the data server
(Inherited from DataServer.)
Public propertyIndexColumns
Public propertyLASTREC
**Missing documentation **
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 propertyRecCount
A numeric value representing the number of rows in the data server.
(Overrides RecCount.)
Public propertyCode exampleRecno
A numeric value representing the relative position in the data server.
(Overrides RecNo.)
Public propertyRecNo
A numeric value representing the current record number, identifying the position of the record pointer in this data server.
(Inherited from DataServer.)
Public propertyRowCount
Public propertyScrollConcurrency
A constant, which describes the concurrency mode used by the SQL statement:
Public propertyScrollUpdateType
A constant, which describes the type of SQL statement to use during append, update or delete operations.
Public propertySimulateCursor
A constant, which describes the way the ODBC drivers tries to guarantee that update or delete statements only affect one single row.
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