Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Long fields with excel
Message
 
À
25/08/2005 16:30:29
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01044055
Message ID:
01044171
Vues:
12
As in Excel Help:
Excel has 15-digit limit Regardless of the number of digits displayed, Excel stores numbers with up to 15 digits of precision. If a number contains more than 15 significant digits, Excel converts the extra digits to zeros (0).
*-----------

And VFP has 16 digits of precision.

*------------
Could you tell more about what are you doing and why do you need such a precision? See if it is appropriate to store numbers as text:

CREATE CURSOR irepo (fld1 n(16), fld2 c(16))
ln=4568150590713391

INSERT INTO irepo VALUES (ln+recn(),TRANSFORM(ln+recno()))
INSERT INTO irepo VALUES (ln+recn(),TRANSFORM(ln+recno()))

copy to c:\yy xls



>yes but now that instruccion put into excel 4568150590713390
>but is this 4568150590713391
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform