Make sure that you have the latest ODBC driver for MySql. You can also use SQLCOLUMNS() VFP function to see what field properties ODBC reports .


>Hi all, I am building some views from a mysql table but why does the column datatypes does not match in vfp ?
>
>For example a numeric value of length 6 appears there as length 1 and how to set every field, can't this be done automatic ?
>
>Thanks