TAdsQuery.SQLTimeout

Advantage TDataSet Descendant

  This is the first topic This is the last topic  

TAdsQuery

Specifies the SQL Timeout value for this TAdsQuery component.

Syntax

property SQLTimeout: integer

Description

Use SQLTimeout to specify a timeout (in seconds) for this query component. For any query that exceeds the SQLTimeout value, the query is cancelled, and error 7209 (SQL Query aborted by user) is returned to the client.

NOTE: If an SQLTimeout value is configured for this component, that value will override the SQLTimeout value configured for the associated TAdsConnection component.

The SQLTimeout setting will independently apply to the initial query execution, and to any operation that supports Advantage callback functionality, such as record movement operations (TAdsQuery.First, TAdsQuery.Last, etc.) See Callback Functionality for an exhaustive list of operations that support callback functionality and for more information.

NOTE: The SQL timeout setting applies to an entire SQL operation from start to finish. (For instance, if a table that has a trigger defined is updated via SQL, the timeout value applies to the update operation, in addition to the trigger execution time.)

See also

TAdsConnection.SQLTimeout

AdsSetSQLTimeout

Callback Functionality