Subject Parameterized query fails on udf
Author Yves Glodt
Hi,

I have a problem with a query that fails whenever I put a parameter as an UDF
variable: Consider this:


... and SIMPLE(LIBELLE1) LIKE('%'||SIMPLE(?)||'%') order byLIBELLE1 ...
Error code: -804
Error message: Dynamic SQL Error SQL error code = -804 Data type unknown


When I replace the ? with '$q' it works. Is this due to my udf or due to
firebird, or tp php...?


Best regards!
Yves