>To make SQL views work with any number of decimals and
>value size we must put (Field - Field) as XYZ
>in the Create SQL View to make it work.
>
>Thanks to all...
>
>Peter
>
>PS: MS could FIX this in VFP 7.0
Suggest you take a look at
DBSetProp('Your_view.your_field', 'Field', 'DataType', "N(10,1)")