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:
01304409
Vues:
24
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.

>>>Had any numeric columns definitions in SQL table been changed recently?
>>
>>I talked to the DB admin and he indicated no.
>
>Maybe a numeric columns size has been inctreased a while ago w/o view adjustment but only recently numeric value that exceed vied field size has been added? IOW, compare SQL Table and view column sizes.
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform