Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with decimals in remote views with Oracle
Message
From
08/11/2000 03:57:04
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00438691
Message ID:
00439156
Views:
33
>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.
---------
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform