TPSQLDirectQuery.Methods

Please see TPSQLDirectQuery methods short descriptions below:

In TPSQLDirectQuery:

Close()

Closes the dataset.

FieldIndexByName()

Returns field index by its name.

FieldIsNull()

Used to determine if field value is NULL.

FieldValueByFieldName()

Returns field value by it name.

First()

Positions the cursor on the first record in the dataset.

Last()

Positions the cursor on the last record in the dataset.

MoveBy()

Positions the cursor on a record relative to the active record in the dataset.

Next()

Positions the cursor on the last record in the dataset.

Open()

Opens the dataset.

Prior()

Positions the cursor on the previous record in the dataset.

Refresh()

Refreshes the dataset.