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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement