version 2004
ODBC SET OPTION (option; value)
Parameter | Type | Description | |
option | Longint | Number of option to set | |
value | Longint | New value of option |
Description
The ODBC SET OPTION command is used to modify the value of the option passed in option.
option can have one of the following values, located in the "External Data Source" theme:
Constant | Description and possible values |
OBDC Asynchronous (1) | 0 = Synchronous connection (default value), |
1 (or value other than 0) = Asynchronous connection | |
ODBC Max Rows (2) | Maximum number of rows in resulting group |
(used for previews) | |
ODBC Max Data Length (3) | Maximum length of data returned |
ODBC Query Time Out (4) | Maximum timeout awaiting response when executing |
the ODBC EXECUTE command. | |
Values: time in seconds | |
By default: no timeout | |
ODBC Connection Time Out (5) | Maximum timeout awaiting response when executing |
the ODBC LOGIN command. | |
This value must be set before opening the connection | |
in order to be taken into account | |
Possible values: time in seconds | |
By default: no timeout |
See Also
System Variables or Sets
If the command was properly executed, the system variable OK returns 1. Otherwise, it returns 0.