Hi Werner, Dne 4.2.2015 v 17:11 Werner werner...@gmx.ch [firebird-python] napsal(a): > > result = session.connection().execute(s, fk_authuser_id_1=1, > maturityfirst_1='', maturityfirst_2='') > > for i in result: > print(i) > > The two "maturityfirst" are integer columns and I inadvertently used a > string for the filter value. > > It would be nice if fdb could get a more detailed error to make it > easier to track down such an error.
I see. The problem is that FDB supports automatic conversion from string values like KInterbasDB did, because it's feature of Firebird. It's also documented, see http://pythonhosted.org//fdb/usage-guide.html#implicit-conversion-of-input-parameters-from-strings So if you wouldn't use empty strings but numeric strings like '12565' it would work just fine. The conversion is done by Firebird, not by FDB (driver just changes XSQLVAR.sqltype to SQL_TEXT and passes the string parameter value to client library, so it's not checked for validity in any way (you know, it could be a date, timestamp, decimal or float etc. not just integer). if there is any problem, it's detected an reported by Firebird client (in this case it's SQLCODE: -303) so FDB couldn't help you here with more detailed error message. best regards Pavel Cisar IBPhoenix
