Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric fields in new record not showing zeros
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00292083
Message ID:
00292627
Views:
15
>I believe it is because the value is null not zero. To solve this modify the table to have a default value of zero for that field.
>
>>Why, in VFP 6, in newly added records, do numeric fields appear blank instead of showing zeros? I notice this 1) on a form, where the control sources for the objects are the numeric fields, and 2) when I browse the table.
>>
>>It creates a problem in my form since I've marked the objects SelectOnEntry, but SelectOnEntry doesn't appear to work on the objects where the control source is a numeric field which has yet to have a value entered into it.

It's a free table.
Previous
Reply
Map
View

Click here to load this message in the networking platform