Hi Jim,
I understood how the numeric values are stored in the DBF. What I don't understand is why ADO has this problem. If for example you have a numeric field say N(4,0) with any value over 999, ADO craps out returning the value. Shouldn't ADO be able to return a value of 1000? I personally consider this a bug but like I said it may be a feature.
Watching the John Peterson thread where he stated that ADO does not support (not compatible with) numeric field type. What!?? I sure have used a lot of ADO on VFP numeric fields - Houston, we have a problem. Outside of the numeric resolution issue, ADO has "appeared" to work fine with numeric fields.
Recently bought a VFP 3 book on sale for my dad that you co-authored, he's moving up from FP DOS. He really likes it and has helped him a lot - Thanks.
Regards,
Mike
Michael McLain