Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LOCATE for .NULL.?
Message
From
11/11/1998 09:48:20
 
 
To
11/11/1998 09:44:32
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00156567
Message ID:
00156570
Views:
30
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform