List Fields In A Memory Table

If I query SQL Server 2005 with code like:

Connect to DB
SQLExec("SELECT * FROM tablename WHERE pkfieldname = 1", "Qry1")
SQLFirst("Qry1", 1)

I now want to spin through all of the fields in Qry1 (only 1 record), something like:

FOR i = fieldcount THEN

// I know I can get the field's value using
SQLCol("Qry1", i)

BUT how do I get the name of that field?????


TIA, Kevin

Hi Kevin,

Check out SQLinfo() and then SQL.TitleCol[x]

If you want to make a table of some type you could use a "FOR" loop with SQL.NbCol as the max and then build a string in the loop with TABs between each column title.

Cheers!
ken