Hi , I using MySql from Visual Foxpro cross over ODBC 3.51 . When I run a SELECT statement then the DECIMAL 15,0 MySql field arrived to Foxpro as Currency type with 4 digits decimals! The data not lost (15 digits long) but ,the decimals set to 4 and column type is Currency .
I must always use the MTON() Foxpro function for convert data to numeric data type. That is my problem... By: Zoltan