Leon,
At 09:32 AM 18/07/2003 +0200, you wrote:

>Hi,
>
>If I put parameters outside the WHERE clause (works perfectly in combination
>with firebird) IBO (latest build) messes up the parameters
>In this case mydate processes as "string" in stead of "date" and myEMployee
>processes as "date" in stead of "string"
>
>SELECT
> SUM( CASE WHEN date = :mydate THEN hours ELSE 0 END ) as TotalThisDay,
> SUM( hours ) as TotalThisWeek,
>FROM
> mytable
>WHERE
> employee = :myemployee
>AND
> date >= :myMonday and date <= :mySunday

Are you using Firebird 1.5?

Helen