Posted by Daft Pict on 01/30/08 16:34

Greetings,
I am getting a data conversion error I cannot explain!

This statement

UPDATE dbImageList
set cx = COS(RADIANS(CRVAL2))*COS(RADIANS(CRVAL1)),
cy = COS(RADIANS(CRVAL2))SIN(RADIANS(CRVAL1)),
cz = SIN(RADIANS(CRVAL2))

results in this error message
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type float.
The statement has been terminated.


However, all fields crval1,crval2,cx,cy,cz are datatype float in the
table.

Any suggestions on how to perform this computation?
Thanks
-Brian

[Back to original message]