Hi!


I just got an undesirable behavior when extracting data from an Access table using Visual FoxPro. Numeric fields are truncated to 2 decimals, which is not very useful for precise latitude and longitude data.

I'm using VFP8, Access 2000, and had the same behavior from and ADO or ODBC connection. I even tried using ADO from Delphi and also got that problem. It's very easy to replicate, just create a table and have a field with around 13-15 decimals, insert a record and you'll get only 2 decimals when accessing it from FoxPro.

Any hint would be highly appreciated...!