Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding field information similar to AFIELDS()
Message
From
01/02/2001 16:41:05
 
 
To
01/02/2001 16:31:21
Robert Zinn
Made2Manage Systems, Inc.
Indianapolis, Indiana, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00471467
Message ID:
00471474
Views:
11
>I need to find out information about a field in a table. However, this field may not be in my currently selected table, and I do not want to use AFIELDS because it returns too much information to wade through. Specifcally, I need to know the type, size, and (if applicable) decimal precision of my field. I haven't found a native VFP function that will provide this information for a single field. A simple UDF seems to be my next option, so any suggestions in that direction would be appreciated.

Sorry, AFIELDS() is one of the few ways that can return all the information about a field like width and precision for numeric fields. You can get the number of decimal places, but not the width of a numeric field:
nWidth = 20
nDecimals  = nWidth - RAT(".",PADL(numericfield,nWidth))
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform