FIX: DBSETPROP() for DataType Gives Incorrect ResultsID: Q140303 3.00 WINDOWS kbprg kbbuglist kbfixlist The information in this article applies to:
SYMPTOMSUsing 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:
WORKAROUNDFloat 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.
STATUSMicrosoft 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.
MORE INFORMATION
Steps to Reproduce Problem1. Type the following commands in the Command window:
2. Use the Upsizing Wizard to upsize the table to SQL Server.
3. Type the following command in the Command window:
4. Create a remote view of the table called rem_dec.
5. For each of the following DBSETPROP() function calls, close the view,
KBCategory: kbprg kbbuglist kbfixlist
KBSubcategory: FxotherGeneral VFoxWin DBGETPROP buglist3.00 fixlist5.00
Additional reference words: 3.00
|
Last Reviewed: November 1, 1997 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |