Mark,
You are creating to fields that are N(4,2) which apparently is not big enough to accommodate your results, try using more zeroes like
sele *, 0000000.00 as field1, 0000000.00 as field2 where.. into cursor temp1 readwrite
>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
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges