>For the currently selected table, I want an array of the column names? How do I build an SQL to retrieve the column names?
>
>Thanks
>
>Brenda

Two ways since the table is in use. First, and easiest would be to use AFIELDS(). Second, and while not difficult it does take more code, use FCOUNT() to return the number of fields, then a FOR...ENDFOR loop to retrieve the names using FIELD(< n >). This also has the disadvantage of not telling you anything else about the fields such as data type, size, etc.