Please see TPSQLDirectQuery properties short descriptions below:
In TPSQLDirectQuery
Specifies whether or not a dataset is open.
Indicates whether or not a cursor is positioned at the First record in a dataset.
Specifies the TPSQLDatabase component this component connects to to perform database operations.
Indicates whether or not a cursor is positioned at the last record in a dataset.
Returns name of a field by its index.
Indicates the number of fields in fetched resultset.
Returns field value by it index.
Indicates whether the dataset is empty.
Contains the parameters for a query's SQL statement.
Indicates or sets the current record number in the dataset.
Indicates the total number of records associated with the dataset.
Contains the text of the SQL statement to execute for the query.