Thanks Sergey.
I looked at your suggestions, but it still didn't give me the answers I am looking for. We are trying to avoid using VFP native and do the process in low level IO in C# .Net. The Excel mskb did touch the IEEE754 (even though they touch base with a 65 bit version.) But from testing with mutliple different numbers by looking directly in a VFP DBF it doesn't show the same type of result as one would expect from following the real IEEE754 standard.
>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?
- Erik Niese-Petersen
Crazy Dane in USA.