Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replacing only blank fields
Message
 
À
16/01/2003 19:48:44
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00742691
Message ID:
00742860
Vues:
13
Thank you Hilmar! I appreciate your help!
Max


>The problem here is that, if you have SET EXACT OFF, all fields will meet >the condition. If you have SET EXACT ON, none will.

>If you know that the character field has 10 spaces, you can use:

>... where Field = space(10)

>However, the easiest method is:

>... where empty(Field)

>This works for most data types! Characters with only blank, memos that are >either empty or only blanks, numerics = 0, empty dates.

>Hilmar.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform