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