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:
00292633
Views:
23
>>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.
>
>This goes all the way back to the beginning of Fox. The fields are blank because there has never been a value. If you table is a member of a DBC, you can set the default value to 0 for all these fields.

In earlier versions of Fox numeric fields that hadn't been assigned a value stored and stored a zero. The tables I'm using are free tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform