Brenda,

A little off the subject, but here's a handy trick with AFIELDS() that you may not know. It copies the structure of a table and makes a cursor:

SELECT MyTable
=AFIELDS("laTempArray")
CREATE CURSOR MyCursor FROM ARRAY laTempArray


>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