>>>>>I need to check for blank record. That means, all the flds must
>>>>>be empty. I do not want to check each fld. Is there a way to check
>>>>>if the entire record is empty.
>>>>
>>>>Robert,
>>>>
>>>>
>>>>LOCAL llEmpty, lnCnt
>>>>llEmtpy = .T.
>>>>FOR lnCnt = 1 TO FCount()
>>>> IF NOT EMPTY( Field(lnCnt) )
>>>> llEmpty = .F.
>>>> EXIT
>>>> ENDIF
>>>>ENDFOR
>>>>RETURN llEmpty
>>>>
>>>-----
>>>Hey Jim,
>>>Are we saying, the FOR LOOP only checks the current record and if the
>>>current record is not empty, I get a return .f.... ?
>>
>>Robert,
>>
>>That's exactly what we're saying.
>-----
>Jim,
>I am running:
>if EMPTY( Field(1) )
> ? 'you fld is empty'
>endif
>
>I am checking the first fld in my table. I know it is empty,
>but the code thinks there is something in the fld. Could
>there is some hidden charaters in the fld?
use EMPTY(EVAL(field[1])) to check if the CONTENTS of the field is empty.