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--