Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric data displays incorrectly
Message
From
27/07/2005 10:13:28
Robert Craill
Tivvit Solutions (Pty) Ltd
South Africa
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Numeric data displays incorrectly
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01036211
Message ID:
01036211
Views:
44
Got a view that gets data from SQL server.
In view have a numeric field n(14,2). In sql the value is 3000 but in the view it is 3,000 ( with comma) If you select the field it changes to 3 . it seems the comma cannot be interpruted in the numeric field and thus truncates ie val(3,000) = 3 and not 3000.
Any ideas how to correct this?
Tks
Next
Reply
Map
View

Click here to load this message in the networking platform