Click or drag to resize

SQLStatement Properties

X#

The SQLStatement type exposes the following members.

Properties
  NameDescription
Public propertyConnection
The data source — a SQLConnection object — that this statement is connected to.
Public propertyCursorType
Public propertyErrInfo
An SQL statement error information (SQLErrorInfo) object. Use the error flag of the returned object to determine if an error occurred.
Public propertyHyperLabel
A hyperlabel containing a description of the statement.
Public propertyKeySet
Public propertyNativeSQL
A string containing the native text of the statement. Level 2
Public propertyNumParameters
A numeric value containing the number of parameters in the statement. A return value of -1 indicates an error. Level 2
Public propertyNumSuccessfulRows
A numeric value containing the number of rows that were affected by the insert, update, or delete statement. A return value of -1 indicates an error.
Public propertyParams
Public propertyPrepFlag
A logical value that indicates if the statement has been prepared.
Public propertyRecCount
Public propertyRowSet
Public propertyScrollConcurrency
Public propertySimulateCursor
Public propertySQLString
A string containing the text of the statement.
Public propertyStatementHandle
A long integer representing the statement handle.
Public propertyStatus
A hyperlabel describing the error, or NULL_OBJECT if no error has occurred.
Top
See Also