General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Linking to Access database - Numeric fields truncated
Environment versions
Network:
Windows 2003 Server
Database:
Jet/Access Engine
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...!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only