Graham wrote:

>
> select drid, testid, rdate, loinc, rtype, cast(rvalue as
> decimal(9,3)), runit, rrange, labid from digital where patient = 2832
> order by rdate DESC
>
> and I get an arithmetic error
>
> See http://www.screencast.com/t/dTKWrX19G for ISC error code
>
> but the same query in IBOconsole works fine without DESC

Have you determined which record causes the error?


Best,

Ann