Re: VFP mySQL oddity by Zootal
Zootal
Tue Mar 04 19:12:57 CST 2008
Are you using a parameterized view? If so, edit the sql of the view and
change the data types to what you want them to be. The MySql ODBC drivers
tend to be a tad flaky when used by VFP, and the data type mapping leaves a
bit to be desired. I always go back and manually change the data type
mappings.
"Curious Joe" <joebob.johnson@gmail.com> wrote in message
news:3cb4e0f8-30a2-4dba-94d0-7d3bb3caf283@e6g2000prf.googlegroups.com...
>I have a mySQL 5.x server running atm and am using mySQL ODBC 5.1.1
> and VFP 9 sp2.
>
> When I am querying data from the mysql tables into a cursor, all
> fields defined as decimals are coming into VFP as currency.
>
> Is there a way to force VFP to be smart enough to make them all
> numeric?
>
> Thanks,
>
> CJ