Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why is select sum() from number Oracle column rounded ?
Message
 
 
À
03/12/1999 23:21:04
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00297819
Message ID:
00299039
Vues:
46
Hi Cindy,
Your example is working only in VFP.
Oracle doesn't accept sum(something)+000.000 ...

I don't know why, but 'sum_column_returning' is number(20,0).
If SET FIXED is ON, I see decimal places in rows without cursor.
So, after each sum I alter table sum_column to number (20,2). Nice ?

Pavel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform