Hi,

I have the next sql command

sql = 'SELECT 
   "EXPRESSIONS_COMPANY"."ID",
   "EXPRESSIONS_COMPANY"."NAME",
   "EXPRESSIONS_COMPANY"."NUM_EMPLOYEES",
   "EXPRESSIONS_COMPANY"."NUM_CHAIRS",
   "EXPRESSIONS_COMPANY"."CEO_ID",
   "EXPRESSIONS_COMPANY"."POINT_OF_CONTACT_ID",
   ? AS "FOO"
   FROM "EXPRESSIONS_COMPANY"
   WHERE ? = ?
   ORDER BY "EXPRESSIONS_COMPANY"."NAME" ASC'

Running this sql
cur.execute(sql, ['value', 'value', 'value'])

Raise an exception:
 SQL error code = -804 - Data type unknown'

Of course, fdb doesn't replace params from entire sql command, just from where clause.

Is this behavior the standard according to python db-api ?
Is there another approach to accomplish using fdb without make a string replacement ?


Regards
Maxi