Hi Folks,
I am in the process of testing a application which I am migrating
from Interclient 1.6 to jbird 1.5. The database is Dialect 1.

The following SQL (which works fine in interclient)...

insert into pm_measurements (pm_id, mt_id, m_date) select ?,
mt_id ,? from pm_measure_types where ms_id = ?

fails with an Unknown fieldtype error for the two ? in the select
list.

I tried casting the params ...

insert into pm_measurements (pm_id, mt_id, m_date) select cast(? as
integer), mt_id ,cast(? as timestamp) from pm_measure_types where
ms_id = ?

but this failed.

Is this is known problem?

Regards
Ian Newby