Check
Floating-point arithmetic may give inaccurate results in Excel mskb #
78113. According to help for
Numeric Data Type it applies to VFP also. Currency is stored as 2 long numbers. See
_RetCurrency( ) API Library Routine in help for details.
>I'm in the process of creating a C# class to transfer simple VFP DBFs to Text (CSV style) and back to DBF (This is due to some memory issues with ODBC/OleDB). But I have run into a problem how to work with the floating points (double/currency fields) in the DBF. It doesn't look like they are stored as standard IEEE 754 floating points. Can anyone where shred some light on this for me on how to read and transfer the bytes?
--sb--