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.

Thank you

--- In firebird-support@yahoogroups.com, Doug Chamberlin <dougchamberlin@...> wrote:
>
> On 12/22/2010 11:20 AM, kokok_kokok wrote:
> > Why do I get error when I execute it?
>
> It would help us to help you if you would tell us exactly what error
> message or error number.
>
> --
> Cheers! Doug C.
> --
> A: Because it messes up the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
> A: Top-posting.
> Q: What is the most annoying thing in e-mail?
>