Subject | Arithmetic exception on order by DESC |
---|---|
Author | Graham |
Post date | 2008-11-26T19:45:07Z |
This is my query:
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
select drid, testid, rdate, loinc, rtype, cast(rvalue as
decimal(9,3)), runit, rrange, labid from digital where patient = 2832
order by rdate
where rdate is a DATE field.
Using 2.0.1.12855
Do I need to update my FB server?
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
select drid, testid, rdate, loinc, rtype, cast(rvalue as
decimal(9,3)), runit, rrange, labid from digital where patient = 2832
order by rdate
where rdate is a DATE field.
Using 2.0.1.12855
Do I need to update my FB server?