Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting a Numeric value out of range when using view
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01304392
Message ID:
01304418
Vues:
32
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform