Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I tell if an entire record is empty
Message
De
15/09/1998 14:25:12
 
 
À
15/09/1998 14:13:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00136755
Message ID:
00136881
Vues:
15
>>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform