General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only