Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referencing fields in a table using a number
Message
From
10/03/1998 17:58:36
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00083759
Message ID:
00083761
Views:
25
>Sorry folks, I could find the answer to this one in the VFP help...
>
>How do I reference fields in a table by field# rather than the name of the field. I will be doing this from a report and not in the SQL.

Just used this myself...
=AFIELDS(aArray) <- inserts field information into an array. Quite useful.

 - Or -

FIELD(lnI) <- returns the name of field number lnI in the table. 
              Note that the alias is *not* returned.
Both of these can take a work area name or number as optional parameters.
David M. Stowell
Ravenslake Consulting
Chicago, Illinois

e-mail: davidstowell@ravenslakeconsulting.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform