FIX: DBSETPROP() for DataType Gives Incorrect Results (140303)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
This article was previously published under Q140303 SYMPTOMS
Using the DBSETPROP command to change the datatype property of a field for
a remote view gives incorrect results for the number(N) and float(F)
fields. Attempting to change the number of decimal positions for type
float(F) results in asterisks appearing in the field. Changing the number
of decimal positions displayed for a numeric field changes only the results
in the active cell in a Browse window. You can change the numbers of
positions displayed in Double (B) fields, and the Browse window will
reflect the correct number of positions displayed for active and inactive
cells. Currency (Y) fields always display four decimal places. Attempts to
change this result in the following error message when the BROWSE command
is issued:
Datatype property for field 'fieldname' is invalid
WORKAROUND
Float fields and numeric fields behave the same way. Use N instead of F
when trying to change the number of displayed positions for a float field.
However, the new number of decimal positions displayed only effects the
active cell in a browse.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem has been fixed in
Visual FoxPro 5.0 for Windows.
Modification Type: | Major | Last Reviewed: | 3/24/2000 |
---|
Keywords: | kbbug kbvfp500fix KB140303 |
---|
|