Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Leading zeros in Numeric field?
Message
 
 
À
07/03/2002 12:12:08
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00629689
Message ID:
00630266
Vues:
23
Pete,

If the value is stored as numeric, your only choice is to hunt down every use of the field and PADL() it.

If the value is stored as C(3) then you can update the table one time to fill the leading 0s, but then you are still faced with the code changes required to move from a numeric to a character field.

>I would like to have leading zeros available in numeric fields; FPW2.6. Problem is that App is already done and this is needed for another app's (not being done by me) input data. I know I can PADL(), but I access this field(s) in hundreds of places and I don't want to have to locate every line with the variable in it. I've tried things like VAL(), but it converts 006 to 6.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform