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