Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting a Numeric value out of range when using view
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01304392
Message ID:
01304418
Views:
34
VFP takes the size of decimal SQL column and add 1 for sign and 1 more for decimal point.

>Comparing them just shows that VFP converts SQL Server field sizes for numeric into what VFP wants. I did nto create this view manually, I used the create view inside the VFP DB Designer. So if I am looking at the SQL Server table and see a Numeric Field of 6,3 then VFP shows the same field in the view as 8,3 or if the SQL Server had a field of Numeric 5,0, then VFP show the same field in the view as 7,0. What formula did VFP use to convert these descriptions? As it is obvious that they do not mean the same thing.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform