That's very perceptive of you, and was the case. Someone entered a
twenty digit number into my web form :(

--- In firebird-support@yahoogroups.com, "Anderson Farias"
<peixedragao@...> wrote:

>
> Hi,
>
> > but the same query in IBOconsole works fine without DESC
>
> Have you feched all records?? (scrolled down to the end of the grid or
> something like?)
>
> The error probably comes from "cast(rvalue as decimal(9,3))" and it

is on

> the first record when using 'desc' and last when not using, than,

until you

> fetch this record you will not get the error.
>
>
> Regards,
> Anderson Farias
>