| Subject | Re: [firebird-support] Arithmetic exception on order by DESC |
|---|---|
| Author | Anderson Farias |
| Post date | 2008-11-26T20:35:04Z |
Hi,
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
> but the same query in IBOconsole works fine without DESCHave 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