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

  • [firebird-python] fdb 1.... Werner werner...@gmx.ch [firebird-python]

Reply via email to