Sets the SQL Timeout on a Connection or Statement.

Syntax

Parameters

Remarks

AdsSetSQLTimeout sets the optional SQL timeout value (in seconds) for a given connection or statement handle. When a timeout is specified for a connection handle, that timeout value will apply to all SQL statement handles created on that connection. When a timeout is specified for a statement handle, the SQL timeout applies only queries executed on that statement object. For any query that exceeds the Timeout value, the query is cancelled, and error 7209 (SQL query aborted by user) is returned to the client.

If an SQL timeout is specified for both the statement and the associated connection, the statement SQL timeout will be used.

The SQL Timeout setting will independently apply to the initial query execution, and to any operation that supports Advantage callback functionality, such as record movement operations (AdsSkip, AdsGotoRecord, AdsGotoTop, 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.)

Example

AdsCreateSQLStatement( hConnect, &hStatement );

// Set a 5-second SQL Timeout

AdsSetSQLTimeout( hStatement, 5 );

// This query will have 5 seconds to finish

AdsExecuteSQLDirect( hStatement,

"select * from demo10",

&hCursor );

// This call will also have 5 seconds to finish

AdsGotoBottom( hCursor );

// Now clear the SQL timeout

AdsSetSQLTimeout( hStatement, ADS_DEFAULT_SQL_TIMEOUT );

 

See Also

Callback Functionality