>>>Hi. I have a DBF with one record (simple enough). How would I refer to the field names if I were looping through them (looking for any with a value).
>>
>>To paraphrase Terry. No macro sub required.
>
>Just can't resist:
>
>

>For I = 1 to FCOUNT()
>  lcField = forceext(ALIAS(), FIELD(m.I))
>  If not EMPTY(eval(m.lcField))
>      ....
>  Endif
>EndFor
>

Interesting. I wouldn't have thought of using force extension to make the field the extension of the alias. How about this:

m.lcAlias = ALIAS() + "."
For I = 1 to FCOUNT()
  If not EMPTY(eval(m.lcAlias + FIELD(m.I)))
      ....
  Endif
EndFor