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