PRB: Remote View of 2.x Table Changes Numeric Field Data TypeLast reviewed: March 27, 1996Article ID: Q145608 |
The information in this article applies to:
SYMPTOMSWhen you create a remote view based on a FoxPro 2.x table and a numeric field is present, the view will change the data type of the field to a double that defaults to two decimal places.
CAUSEThe field type is determined by the ODBC driver in use.
RESOLUTIONBefore the view is opened for a browse, issue the following command:
=DBSETPROP('<View_name.fieldname>','field','datatype','n(<nX>,<nY>)')In this example, the <View_name.fieldname> is the name of the remote view and field. The <nX>, <nY> in the n parameters should be replaced with the original field size followed by a comma and then the original decimal places.
STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce Problem
|
Additional reference words: 3.00 3.00b VFoxWin sql
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |