Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting the type of a field
Message
 
To
11/07/2001 13:52:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00529271
Message ID:
00529294
Views:
12
>>>>>I have an array which contains the name of some fields in my table. From that array, I would like to extract the type of the field. Is there a way to do that from the array?
>>>>
>>>>
>>>>? type(myfields(i))
>>>>
>>>
>>>That returns N even if my field type is I.
>>
>>Why not use AFIELDS() find the matching field name and get the data type from column 2?
>
>Yes, that seems to be the only solution to do. But, why TYPE doesn't work on integer?

Don't know, but it's documented that TYPE() and VARTYPE() return N for Numeric, Integer, Double, and Float datatypes.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform