Fw: column type problem

[Szmutku Zoltán]

Hi ,

More column type problem ...The MySql  Text fields arrived as General (not readable) field
in VFP via ODBC... 

By: Zoltan

----- Original Message ----- 
From: Szmutku Zoltán 
To: mysql@stripped 
Sent: Monday, October 24, 2005 10:36 AM
Subject: column type problem 


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