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:56:28
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00136755
Message ID:
00136910
Views:
18
>>>>>>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.
------
That is it -EMPTY(EVAL(field[1]))- it works ... thanks Fred and everybody... :)
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Previous
Reply
Map
View

Click here to load this message in the networking platform