Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I tell if an entire record is empty
Message
From
15/09/1998 14:25:12
 
 
To
15/09/1998 14:13:07
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00136755
Message ID:
00136881
Views:
16
>>>>>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.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform