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:40:03
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
21/11/2002 22:17:09
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00725567
Message ID:
00725601
Vues:
19
>>>Is there anyway at all to get a numeric field to display 3 zeros?
>>
>>Not that I know, but one could store 3 zeros in a string. You could have 3 numeric fields and use features embedded in Textbox to make the 3 zeros appear a single field.
>>
>Hi Terry:
>
>Thank you for your reponse. I have a situation where I have classified a field as a numeric field, but now have a situation wherein I have to use 000 in that field. For now, I am testing to see if the display in a text fille will be 000 for any field that has a 0 in it.

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").

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform