>You might try copying the field down to a native Currency field.
Thanks for answering Ed. ¿In oracle or in VFP? I've tried in VFP without success. In Oracle is not possible cause data is used from other external applications.
>>>What about my suggestion for issuing a DBSetProp to change the width and decimals for the view field?
>>
>>Of course i've tried. The sqlexec returns the the field is datatype 'number', data_length 22, data_precision 16, data_scale 3 and i've isuue
>>
>>dbsetprop("stocksdeuno.nmpieenti", "field", "datatype", "n(16, 3)")
>>with success but erros in data value remains
>>
>>dbsetprop("stocksdeuno.nmpieenti", "field", "datatype", "n(22, 3)")
>>without success: 'datatype property datatype is not valid'
>>Someone has suggested to me to change in Oracle the data type to number in place of number(16, 3), and he says that then all works fine. But this is not possible for me cause the Oracle tables are used by more external applications.
>>¿More ideas?
>
>You might try copying the field down to a native Currency field.
>
>>Thanks again.
>>
>>>
>>>>>Does the corresponding Oracle field have decimal places? Does --
>>>>>
>>>>>DBGetProp('MyView.MyField', 'Field', 'DataType')
>>>>>
>>>>>return the correct field length and decimals? If not you can --
>>>>>
>>>>>DBSetProp('MyView.MyField', 'Field', 'DataType', 'N(x,y)')
>>>>>
>>>>>to correct the formatting of the views. Keep in mind, everytime you modify the view and save it, you will have to reissue the DBSetProp() commands.
Saludos,
A.G.P.
---------