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