--- In firebird-support@yahoogroups.com, "rj1102" <rjm@...> wrote:

> -902 Dynamic SQL Error expression evaluation not supported
>
> for this statement:
>
> UPDATE Wedstrijd
> SET PouleId = -1*PouleId
> WHERE CompetitieId = 'oizw0607'
> AND Datum < '01-01-2007'
>
> The error seems in the second line

Dates having '-' should be in ISO format:

'2007-01-01'

alternatively, you can use:

'01.01.2007' and '01/01/2007'

First uses 'dd.mm.yyyy' and second 'mm/dd/yyyy' form.

--

Milan Babuskov
http://www.guacosoft.com