My fault. Just ignore this thread from now. I forgot PouleId was
declared as a VARCHAR. I thought it was an INTEGER.
Very Sorry.
Robert

--- In firebird-support@yahoogroups.com, "Milan Babuskov"
<milanb@...> wrote:

>
> --- 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
>