SQLQueryTimeout

Examples


This setting allows you to specify the timeout period - the length of time to wait for a command to be completed before discontinuing the attempt and returning to your application.

Syntax

SQLQueryTimeout = timeout_period

Parameters

timeout_period - The number of seconds to wait before aborting a command.

Comments

This setting limits the length of time Dexterity or your application will wait for a single command to be completed. A completed command is one which returns a value or status code.

If you set your timeout period too low, users could frequently timeout, receiving a message stating that “An open operation on table table_name failed accessing SQL data.”

To cause your application to wait indefinitely for a command to be completed, include this setting in the defaults file and set its value to 0 (zero). If this setting isn’t included in the defaults file, your application will wait 300 seconds (five minutes).

Do not use this setting to set a report timeout period. Use the SQLRprtsTimeout setting instead.



Documentation Feedback