Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Floating Points in DBFs
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01236812
Message ID:
01237123
Vues:
14
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform