Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
LOCATE for .NULL.?
Message
De
11/11/1998 09:48:20
 
 
À
11/11/1998 09:44:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00156567
Message ID:
00156570
Vues:
22
>I just did a left outer join and in the result set
>i have fields with a .NULL. value.
>
>I would like to replace just the .NULL. valued fields
>with a default value, let's say 10 (it is a numeric field).
>
>However, I was unable to find the first .NULL. field
>when trying the below commands:
>
> LOCATE FOR nfld = .NULL.
>
> LOCATE FOR EMPTY(nfld)
>
>In both cases I am brought to the end of the file.
>
>How can I consistently find the .NULL. valued fields?

locate for isnull(nfld)
However, you may also change your outer join syntax to provide default values in first place.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform