Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with decimals in remote views with Oracle
Message
De
08/11/2000 03:57:04
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00438691
Message ID:
00439156
Vues:
34
>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.
---------
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform