Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning the number of decimals a field has
Message
From
14/08/2003 13:24:37
Mark McCasland
Midlothian, Texas, United States
 
 
To
14/08/2003 12:57:26
Chuck Mautz
Avon, Minnesota, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Returning the number of decimals a field has
Miscellaneous
Thread ID:
00820138
Message ID:
00820237
Views:
15
>Thanks I shorted it down to
>
>I need to add the MAX function for whole numbers
>
>ln_dec = MAX(LEN(TRIM(PADR(MOD(field, 1), 21))) - 2, 0)
>
It will still fail if the value of the field is null. AFIELDS will never fail as it is not dependent on the value of the field.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform