Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Diff between 0 and blank in numeric field
Message
De
22/10/1999 17:27:22
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00280270
Message ID:
00280288
Vues:
14
For Numeric data type you could use ISBLANK(), but for Integer.. I don't know.

>Well, I'm just gonna avoid using Zeros for data - but at the moment I'd like to avoid modifying data by hand. Since they're not nulls, any way to differentiate betwixt zeros and nothin?
>
>>>My table includes a numeric field with data from 0 to 2 - but it also has empty fields. I'd like to increase all the numeric entries by one, but I don't want to change the blank values.
>>>
>>>EMPTY() does not seem to differentiate between zeros and blanks, and the blanks don't seem to be nulls. LEN(STR(field)) doesn't do it, either!
>>>
>>>How can I filter out the blank records from the replacement?
>>>
>>>TIA
>>
>>You may better use .NULL. to get true and safe difference.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform