Hi,

I am getting the following error during testing of my application, but
only on Py2.7, if I run the same application on Py3.4 with the same fdb
and SQLAlchemy version I don't see this error.

I'll continue to search for the reason but if someone has a tip, please
let me know.

Werner


File "d:\devMine\twcbv5\twcbsrc\controllers\app_cb.py", line 1277, in
<module>
app.MainLoop()
File "c:\Python27\Lib\site-packages\wx-3.0.1-msw-classic\wx\_core.py",
line 8657, in MainLoop
wx.PyApp.MainLoop(self)
File "c:\Python27\Lib\site-packages\wx-3.0.1-msw-classic\wx\_core.py",
line 7952, in MainLoop
return _core_.PyApp_MainLoop(*args, **kwargs)
File
"c:\Python27\Lib\site-packages\wx-3.0.1-msw-classic\wx\lib\agw\aquabutton.py",
line 439, in OnLeftUp
self.Notify()
File
"c:\Python27\Lib\site-packages\wx-3.0.1-msw-classic\wx\lib\agw\aquabutton.py",
line 890, in Notify
self.GetEventHandler().ProcessEvent(evt)
File "c:\Python27\Lib\site-packages\wx-3.0.1-msw-classic\wx\_core.py",
line 4154, in ProcessEvent
return _core_.EvtHandler_ProcessEvent(*args, **kwargs)
File "d:\devMine\twcbv5\twcbsrc\controllers\app_cb.py", line 714, in
onButtonSearchDo
self.doSearchCB(self.olvList, self.sCtrls, self.sCtrlsFT)
File "d:\devMine\twcbv5\twcbsrc\controllers\app_cb.py", line 739, in
doSearchCB
olvlist.searchItemsQuery(saQuery)
File "d:\devMine\twcbv5\twcbsrc\libui\olvgroup.py", line 195, in
searchItemsQuery
self.listObjects = query.autoflush(False).all()
File
"c:\Python27\Lib\site-packages\sqlalchemy-0.9.7-py2.7.egg\sqlalchemy\orm\query.py",
line 2300, in all
return list(self)
File
"c:\Python27\Lib\site-packages\sqlalchemy-0.9.7-py2.7.egg\sqlalchemy\orm\loading.py",
line 66, in instances
fetch = cursor.fetchall()
File
"c:\Python27\Lib\site-packages\sqlalchemy-0.9.7-py2.7.egg\sqlalchemy\engine\result.py",
line 787, in fetchall
self.cursor, self.context)
File
"c:\Python27\Lib\site-packages\sqlalchemy-0.9.7-py2.7.egg\sqlalchemy\engine\base.py",
line 1160, in _handle_dbapi_exception
exc_info
File
"c:\Python27\Lib\site-packages\sqlalchemy-0.9.7-py2.7.egg\sqlalchemy\util\compat.py",
line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File
"c:\Python27\Lib\site-packages\sqlalchemy-0.9.7-py2.7.egg\sqlalchemy\engine\result.py",
line 781, in fetchall
l = self.process_rows(self._fetchall_impl())
File
"c:\Python27\Lib\site-packages\sqlalchemy-0.9.7-py2.7.egg\sqlalchemy\engine\result.py",
line 748, in _fetchall_impl
return self.cursor.fetchall()
File "c:\Python27\Lib\site-packages\fdb\fbcore.py", line 3454, in fetchall
return [row for row in self]
File "c:\Python27\Lib\site-packages\fdb\fbcore.py", line 3229, in next
row = self.fetchone()
File "c:\Python27\Lib\site-packages\fdb\fbcore.py", line 3414, in fetchone
return self._ps._fetchone()
File "c:\Python27\Lib\site-packages\fdb\fbcore.py", line 3114, in _fetchone
"Cursor.fetchone:")

sqlalchemy.exc.DatabaseError: (DatabaseError) ('Cursor.fetchone:\n-
SQLCODE: -303\n- Dynamic SQL Error\n- SQL error code = -303\n-
conversion error from string " "', -303, 335544569) None None