>How you find the answer for this ?? Microsoft knowledge base has provide
>answer ??

Did not check the MS KB ... I knew that "constants" can influence output field sizes in SQL SELECTs so you should (always) do a LIST STRUCTURE to verify the results. Then it's a matter of playing with the SELECT until you get the effect you want.

>
>--This is one example of how VFP can corrupt numeric table data....
>
>Any others example ?? ^_^

Try this:

CLEAR
CREATE CURSOR TABLE1 (FLD1 C(1), FLD2 C(2), FLD3 N(3,2))

ON ERROR *

SELECT TABLE1
APPEND BLANK

REPLACE FLD3 WITH 34 * 1234.56
?  "(1) "
?? FLD3
?  "(2) "
?? TYPE( "FLD3" )
?  "(3) "
?? FLD3 * 1.0
?  "(4) "
?? FLD3 > 5000000000000

WAIT WINDOW "..."

BROWSE

Scary, huh ?