Peter,

> This fails:
> WHERE ("R"."Resource" IN (' + (ResourceList) + '))
>   AND (CAST("R"."StartDT", DATE) BETWEEN ? AND ?)';
>   PREPARE Stmt FROM SQLStatement;
>   OPEN Result USING ResourceList, DateFrom, DateTo;

That's wrong:

USING ResourceList, DateFrom, DateTo

It has to be:

USING DateFrom, DateTo;

Otherwise EDB tries to use "RecourseList" for the first ? param and
that's a DATE type.

In the second query EDB just skips the param because it's at the end.

Uli