Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Calculate sum / select sum
I have a cursor built by a Oracle OBDC SELECT statement with three fields report_date ( DateTime), jobcode (text), dt_time (Numeric)
When I look at field dt_time in the cursor it shows as a two decimal places number, But when I highlight that record-field, the number changes to a 0 decimal place number, until I move off of the field.
Even stranger is if I use the calculate SUM(dt_time) it will sum the numbers up correctly, If I use a SELECT SUM(dt_time) it treats each number as a interger or ROUND(dt_time,0) would do just like in the cursor does when you hightlight the field.
IE: Unhightlighted HighLighted
.18 0
.38 0
.50 1
2.40 2
.63 1
1.32 1
4.42 4
.17 0
0 0
.01 0
----------------------------------------------------
CALCULATE SUM 10.01 SELECT SUM 9
How do I keep the decimal places in this cursor or during a SQL-SELECT?
Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement