>Chris and Antonio,
>
>Testing for myField = 1/0 returns true on a field with a numeric overflow condition. So this should be a good general solution, or you could SCAN/ENDSCAN and check the condition on each record if necessary:
>

>REPLACE myField with 0 for myField = 1/0

>
>>
>>AFIELDS gives some info, and there are a few more that I cant think of off the top of my head.
>>But by passing the Size and Dec you can use this for more then just a field of an opened database. Making it a general approach.
>>If I was doing something with checking for overflows, I would no doubt do an AFIELDS()
>>then Loop through that, take the size and precision, pass it into the above code, and then replace for myField > maxVal, though it isnt the best way to do the replacement either, replace for locks the entire table if im not mistaken.
>>

I can not get that condition to be true.
I overflowed a field,

?FSize("Num")   => 5
REPLACE Num WITH 99999999999
? Num            => *******
? Num = 1/0      => .F.