Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting the type of a field
Message
 
 
To
11/07/2001 13:50:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00529271
Message ID:
00529289
Views:
13
>>>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?
>>
>>If its an array created with Afields() then the column 2 has the data type of the table column. Otherwise, you could use the TYPE() function (if the table is open.
>>
>>? type(MyArray[1]) && returns evaluation of the data stored in the field name stored in the table
>
>As mentioned in the other reply, that returns N even if the type is I.

In order to get table field types, you have to use AFIELDS(). There is no variable check for these types of data types because there is no variable type of this kind. The same is true for Currency, Float, Double, etc. You need to use a function that actaully reads the table information.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform