Installation guide

7. mxODBC Cursor Objects
Option Comment
SQL.DESC_TYPE_NAME Data source dependent type name of the result set
column or an empty string if the value cannot be
determined.
Returns a string..
SQL.DESC_UNSIGNED Checks whether the result set column is unsigned
numeric data or not.
Returns an integer value:
SQL.TRUE - column data is unsigned or not
numeric
SQL.FALSE - column data is signed
If the ODBC driver doesn't support an
info_id or cannot determine the
requested value, it either raises an exception, or returns an empty string where
applicable.
.getcursorname()
Returns the current cursor name associated with the cursor object. This may
either be the name given to the cursor at creation time or a name generated by
the ODBC driver for it to use.
.getcursoroption(option)
Returns the given cursor option. This method interfaces directly to the ODBC
function
SQLGetCursorOption().
option must be an integer. Suitable option values are available through the
SQL object.
Possible values are:
Option Comment
SQL.ATTR_QUERY_TIMEOUT Returns the query timeout in seconds used for the
cursor.
Note that not all ODBC drivers support this option.
SQL.ATTR_ASYNC_ENABLE Check whether asynchronous execution of commands is
enabled.
Possible values:
SQL.ASYNC_ENABLE_OFF (default)
SQL.ASYNC_ENABLE_ON
SQL.ASYNC_ENABLE_DEFAULT
109