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:13:07
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00136755
Message ID:
00136859
Views:
31
>>>>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?
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform