|
|
Posted by Ed Murphy on 01/31/08 04:18
Daft Pict wrote:
> 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)),
There's a missing * here; is that typo in your actual code, or did it
just sneak in when you wrote your post?
> 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?
First try it with a WHERE clause that limits it to a single row of the
table. If that succeeds, then do a few binary chops to determine which
rows do or don't have problems.
Navigation:
[Reply to this message]
|