>I need to loop thru all the fields in a table to see if they are blank. I know I can use Field but that returns a string which doesn't allow to check to value. How to I change that a string so that I can check if the field is empty.
LOCAL llBlank, lcField,laFlds(1)
SELECT TheAlias
AFIELDS(laFlds)
FOR lnCnt = 1 TO ALEN(laFlds,1)
lcField = "EMPTY(laFlds(lnCnt))"
llBlank = &lcField
IF llBlank
EXIT
ENDIF
ENDFOR
RETURN llBlank