Name 

Description 

 

Bof 

Indicates whether or not a query is at the beginning of the dataset. 

 

DBHandle 

Specifies the database handle for the query. 

 

Eof 

Indicates whether or not a query is at the end of the dataset. 

 

FieldIndex 

Returns the index of the named field. 

 

Fields 

Returns the XSQLVAR fields. 

 

GenerateParamNames 

Generates a list of parameter names for the query. 

 

Handle 

Specifies the handle for the query. 

 

Open 

Determines if the dataset is open. 

 

Params 

Returns the XSQLDA parameters. 

 

Plan 

Returns the plan for the query. 

 

Prepared 

Indicates whether or not the query has been prepared. 

 

RecordCount 

Returns the current count of records from the query. 

 

RowsAffected 

Returns the number of rows affected. 

 

SQLType 

Returns the type of query to be executed. 

 

TRHandle 

Specifies the transaction handle for the query. 

 

UniqueRelationName 

Indicates the unique relation name. 

 

Name 

Description 

 

Database 

Sets or returns the database associated with the query. 

 

GoToFirstRecordOnExecute 

Goes to the first record in the result set upon opening it. 

 

ParamCheck 

Specifies whether the parameter list for an SQL query is regenerated if the SQL property changes at runtime. 

 

SQL 

Sets the SQL query to be executed. 

 

Transaction 

Sets or returns the transaction to be used by the query.