Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to store 3 zeros in a numeric field?
Message
De
21/11/2002 22:46:52
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
 
 
À
21/11/2002 22:40:03
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00725567
Message ID:
00725604
Vues:
18
>Display transform(Field, "@L 999") instead. It will give you leading zeros. But this also means you'll get 001 for 1, 020 for 20 etc. If you need it for zeros only, then transform(Field, iif(field=0, "@L ","")+"999").

Hi Dragan:

Thank you for your kind reponse.

This is a neat idea too. What I have done for now is that I used an If statement to check if the field had a zero. If it did, I then redeclared the variable that holeds that information as a String and then assigned it a value of "000". I will try yoour idea in a report.

Thank you Dragan.
- Ravi

True greatness consists in being great in little things.
- Charles Simmons
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform