>Hi
>when I run scan on cursor for statistics as following , I get the message 'numeric overflow. data was lost' (error 39).
>I get it when I divide value to 0 (For example I have cursor with the columns city, personal (i - count of how many personals in this city), fats (i - count of how many fats there are in this city) and another column is 'onefrom' (i - one from X persons in this city is fat)
> I have to run by scan 'replace cursor.onefrom with cursor.personals/cursor.fats').
>So if unfortunately there are no fats in this city (hypothetical option...), it means that I want to divide number in 0 and I get the message.
>My question is: or how can I voiding the message (If by code I have to fill this code in hunderds places or
>I can tel to vfp ignore this error.) or my system is wrong.
>
>
>help please
Try to make sure you're not dividing by 0 in your code.
This
Re: Numeric overflow Thread #
1236596 Message #
1236604 may help you too.
If it's not broken, fix it until it is.
My Blog