> Sorry, the error is:
>
> ISC ERROR CODE:335544378
> ISC ERROR MESSAGE: feature is not supported
>
> In the other hand, now I see that the problem is the BETWEEN. If I use
>
>
> SELECT * FROM Orders
> WHERE
> CAST(OrderDate + CAST((LfAvgDays+0.5) AS INTEGER) AS DATE) >= '2009/1/1'
> AND CAST(OrderDate + CAST((LfAvgDays+0.5) AS INTEGER) AS DATE) <=
> '2010/1/1'
>
> then it works fine. The problem is solved but I am curious about why
> BETWEEN does not work here.

What is your Firebird version, and what is the dialect version of your database?

Mark
--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 100,- Euro! https://freundschaftswerbung.gmx.de