[DB-SIG] fetchall() problem
Michael Guidry
michael.guidry@trigenttech.com
Fri, 7 Apr 2000 14:34:58 -0500
Why doesn't this cursor.fetchall() work?
>>> import ODBC.Windows
>>> conn = ODBC.Windows.Connect('FL_BS')
>>> cursor = conn.cursor()
>>> cursor.execute('SELECT AMTYP, AMLDS, AMDES FROM ATYMAST')
>>> from pprint import pprint
>>> pprint(cursor.description)
(('AMTYP', -9, None, None, 2, 0, 1),
('AMLDS', -9, None, None, 30, 0, 1),
('AMDES', -9, None, None, 12, 0, 1))
>>> data = cursor.fetchall()
Traceback (innermost last):
File "<interactive input>", line 1, in ?
InterfaceError: SQL type (code -9) not implemented
>>> dir(cursor)
['arraysize', 'close', 'colcount', 'columnprivileges', 'columns',
'datetimeformat', 'description', 'execute', 'fetchall', 'fetchmany',
'fetchone', 'foreignkeys', 'getcursorname', 'gettypeinfo', 'primarykeys',
'procedurecolumns', 'procedures', 'rowcount', 'setcursorname',
'setinputsizes', 'setoutputsizes', 'specialcolumns', 'statistics',
'tableprivileges', 'tables']
Regards,
Michael Guidry