SqlSetTime%

Sets the number of seconds that DB-Library for Visual Basic waits for a SQL Server response during calls to SqlExec%, SqlOk%, SqlResults%, SqlNextRow%, and SqlRpcExec%.

Syntax

SqlSetTime% ( timeout% )

where

timeout%

Is the number of seconds that DB-Library for Visual Basic waits for a SQL Server response before timing out. The default value of 0 represents an infinite timeout period.

Returns

SUCCEED (1) or FAIL (0).

Remarks

SqlSetTime% sets the length of time in seconds that DB-Library for Visual Basic waits for a SQL Server response during calls to SqlExec%, SqlOk%, SqlResults%, SqlNextRow%, and SqlRpcExec%. SqlSetTime% can be called at any time before or after a call to SqlOpen%. It takes effect immediately upon being called. The SqlSetTime% function does not override existing network timeout settings.

To set a timeout value for calls to SqlOpen%, use SqlSetLoginTime%.

When an application sends a statement to SQL Server using SqlExec%, control is not returned to the calling application until SQL Server completes processing the statement or until the timeout expires. If you want your application to continue execution while SQL Server is processing the statement, send the statement with SqlSend%, continue its processing, and then, when it is ready to retrieve the results, call SqlOk%.

The application can call SqlGetTime% to learn the current timeout value.

See Also

SqlExec%, SqlGetTime%, SqlOk%, SqlRpcExec%, SqlSend%, SqlSetLoginTime%