Installation guide

mxODBC - Python ODBC Database Interface
Option Comment
SQL.ATTR_MAX_LENGTH Returns the length limit for fetching column data.
Possible values:
Any positive integer or
SQL.MAX_LENGTH_DEFAULT (no limit)
SQL.ATTR_MAX_ROWS Returns the maximum number of rows a .fetchall()
command would return from the result set.
Possible values:
Any positive integer or
SQL.MAX_ROWS_DEFAULT (no limit)
SQL.ATTR_NOSCAN Check whether the ODBC driver will scan the SQL
commands for ODBC escape sequences or not.
Possible values:
SQL.NOSCAN_OFF (default)
SQL.NOSCAN_ON
SQL.NOSCAN_DEFAULT
SQL.ROW_NUMBER Returns the row number of the current row in the result
set or 0 if it cannot be determined.
The method returns the data as 32-bit integer. It is up to the caller to decode
the integer using the
SQL defines.
.next()
Works like .fetchone() to make cursors compatible to the iterator interface
(new in Python 2.2). Raises a
StopIteration at the end of a result set.
.nextset()
This method will make the cursor skip to the next available set, discarding any
remaining rows from the current set.
If there are no more sets, the method returns
None. Otherwise, it returns a
true value and subsequent calls to the fetch methods will return rows from the
next result set.
An Error (or subclass) exception is raised if the previous call to .execute*()
did not produce any result set or no call was issued yet.
110