Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to store 3 zeros in a numeric field?
Message
From
21/11/2002 22:46:52
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
 
 
To
21/11/2002 22:40:03
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00725567
Message ID:
00725604
Views:
15
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform