Hi, all.

I'm converting an application written in VC++ for Sybase through ODBC
for Firebird 1.5, using IBPhoenix ODBC driver 1.02.00.64
Server Version: WI-V1.5.0.4306 Firebird 1.5
Server Implementation: Firebird/x86/Windows NT
Service Version: 2

The next query (ODBC syntax) return with an error:
SELECT
Tbl1.Fld1 AS t1xxx,
Tbl1.Fld2 AS t1yyy,
Tbl2.Fld3 AS t2zzz,
Tbl2.Fld4 AS t2kkk
FROM Tbl1, Tbl2
WHERE Tbl1.Fld1 = Tbl2.Fld1
AND ( Tbl2.Test1 = 'N' OR Tbl2.Test2 = 'P')
AND Fld3 LIKE ? + '%'
ORDER BY Fld3

The errore report in the log file is:
DIAG [HY000] Dynamic SQL Error
expression evaluation not supported (335544569)

I controlled the above query in IbExpert (changing only the incompatible
syntax in " LIKE :param1 || '%' ") and run fine.
I've searched some mail databases and FAQ but I wasn't able to found
something valuable to solve my problem (really, maybe I don't know what
exactly search for)
Any hints?
Sorry for my simplicistic italian-thinking english.
TIA to everybody.

Mimmo.