The MySQL ODBC driver had a problem with mapping MySQL decimal fields to currency fields in FoxPro, instead of numeric fields.
This nasty bug has been fixed in the latest version of the driver, both the 3.x and 5.x:
mysql-connector-odbc-3.51.25
mysql-connector-odbc-5.1.4
Thanks go to Christian Ehlscheid for diagnosing it, and to the MySQL team for fixing it.
See
http://bugs.mysql.com/bug.php?id=35581Carlos Alloatti