Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric fields with no entry
Message
From
03/02/2000 09:09:50
 
 
To
02/02/2000 17:40:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00326471
Message ID:
00326646
Views:
19
>In VFP browses a numeric field that has never had a value entered appears as blank. If a value, say zero, is entered, the value appears and if it is deleted, it will still display zero.
>
>How does one determine whether a field has ever had a value entered?
>
>Thanks

To add to what the others have said, you can use the ISBLANK() function to determine if the field is blank. But you'll have to programmatically control access to the field(s) and determine on the fly if a value has (not) been entered. Depending on your requirements, ss Ed suggested, probably using NULLs is the better way to go.

Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform