Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upsizing Wizard woes
Message
 
To
01/07/1998 21:19:37
Brian Lee
World Access Network, Inc.
Vancouver, Washington, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00113635
Message ID:
00140823
Views:
27
We're having the same problem with our Conversion. The SQL Server side is dropping the Decimal digits so that 123.45 comes out as 123.4... Does anyone have any ideas on this?

>Having trouble with conversion from VFP 5.0, to SQL Server 6.5- using the Upsizing Wizard. Seems that all of my Numeric fields in VFP do not translate properly to MSSQL Numeric. Must I only accept the default of "Float"? These are fixed-precision, so I assumed the SQL Numeric type would be easiest to deal with. Also difficulty translating from Currency to Smallmoney- the "change" is wiped out, data lost and zeroes substituted in both cases.
Previous
Reply
Map
View

Click here to load this message in the networking platform