Installation guide

mxODBC - Python ODBC Database Interface
.rowcount
This read-only attribute specifies the number of rows that the last
.execute*() produced (for DQL statements like select) or affected (for SQL
DML statements like
update or insert).
The attribute is
-1 in case no .execute*() has been performed on the cursor
or the rowcount of the last operation is not determinable by the interface or
the database.
You should check whether the database you are interfacing to supports
.rowcount before writing code which relies on it. Many databases such as MS
Access and Oracle do not provide this information to the ODBC driver, so
.rowcount will always be –1.
.rownumber
This read-only attribute provides the current 0-based row position of the
cursor in the result set. The next
.fetch*() will return rows starting at the
given position.
The row position is automatically updated whenever the cursor moves through
the result set, either due to fetches or scrolls.
The attribute is
None in case no .execute*() has been performed on the
cursor or the cursor position cannot be determined.
mxODBC provides a
.rownumber emulation on the client-side for databases
that do not implement the ODBC feature, such as e.g. MS Access, Teradata or
Oracle. If the emulation cannot be provided, the attribute will return
None.
.stringformat
Attribute to set the conversion format for string columns on a per cursor basis.
It takes the same values as the
connection.stringformat instance variable
and defaults to the creating connection object's settings for
connection.stringformat.
.timestampresolution
Attribute to set the timestamp resolution for timestamp input columns on a per
cursor basis. It works in the same ways as the
connection.timestampresolution instance variable and defaults to the
creating connection object's settings for
connection.timestampresolution.
.warningformat
Attribute to set the database warning reporting method used by the mxODBC
default error handler. It takes the same values as the
connection.warningformat instance variable and defaults to the creating
connection object's settings for
connection.warningformat.
138