Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding field information similar to AFIELDS()
Message
From
01/02/2001 16:53:58
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00471467
Message ID:
00471486
Views:
20
>>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.
>
>Create a UDF using AUsed(), FCount(), FSize() and Field() functions to at least find the table with the needed field name. However, once you find the correct table, I do not know how to get the decimals without using afields().

Hey Mark...

You knew how to get the field size, and I knew how to get the decimals. Put the two together and he's got it. :)
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform