Getting Column Descriptions in Code

[Stanley - stanlyn.com]

Hi Ken,

Thanks, just what I needed.

Stanley




-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Monday, October 3, 2016 12:38 PM
To: Stanley - stanlyn.com <stanley at stanlyn.com>; filepro-list at lists.celestial.com
Subject: Re: Getting Column Descriptions in Code

On 10/3/2016 4:30 AM, Stanley - stanlyn.com via Filepro-list wrote:
> Hi,
>
> When defining a table we do.
> 1 First Name 20 uplow
> 2 Last Name 20 Uplow
> 3 Address     40 Uplow
>
> In code we reference the fields above by its field number.  What I 
> want to do is get the column/field number's description in code.  Like 
> aa=field1's description, therefore for row 1 above aa would equal 
> "First Name" and NOT the stored user data of "John Smith".  Instead I 
> need the column's description/name.  This is column specific and NOT row specific.
>
> Any ideas?
>
> I'm using fp 5.0.14

Sounds like you want FIELDNAME().

--
Kenneth Brody