Are you ensuring that the values being multiplied are greater than zero?
What is the table structure? Is the field sufficient to hold the results?
>hi all,
>I have a problem updating a writable cursor. basically it goes like this
>
>sele *, 0.00 as field1, 0.00 as field2 where.. into cursor temp1 readwrite
>do while not eof
>
> repl field1 with numeric_value * 2.5
> repl field2 with field1 * other_numeric_field
>
> loop
>enddo
>
>i get a numeric overflow error on these two lines sometimes but i have no idea why, any ideas?
>~M
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"