Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Leading zeros in Numeric field?
Message
 
 
To
07/03/2002 12:12:08
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00629689
Message ID:
00630266
Views:
22
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
Previous
Reply
Map
View

Click here to load this message in the networking platform