Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I check if numeric field is 0 or blank
Message
De
26/08/1999 13:30:33
 
 
À
26/08/1999 10:23:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00257901
Message ID:
00258048
Vues:
20
Thanks, but it didn't work.
Here is the results of some of my testing.

goto 2 this is 0.0
?isnull(hcl) shows false (right to me)
goto 3 This is a blank
?isnull(hcl) shows false (wrong to me)
go bott This is a newly appended blank record with only Sampl# & date
?isnull(hcl) shows false (wrong to me)
goto 2 thi is 0.0
? empty(hcl) shows true (wrong to me)
goto 3 this is blank
? empty(hcl) shows true (right to me)
go bott this is a new blank record
? empty(hcl) shows true (right to me)

The hcl field is Numeric 4,1 decimal I had the NULL box checked, origianlly I didn't but the results were the same.

Any more ideas would be really appreciated.
Thanks. Gary
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform