Even stranger, adding 1 to realhrs gives 1 in every row.
R>connect wdoss
Database Exists
R>select realhrs, safhrs, callhrs, (realhrs+1) as mytothrs from t3t
realhrs safhrs callhrs mytothrs
--------------- --------------- --------------- ---------------
8. 0. 0. 1.
10. 0. 0. 1.
7. 0. 0. 1.
7.25 0. 0. 1.
10. 0. 0. 1.
6.5 0. 0. 1.
8. 0. 0. 1.
1. 0. 0. 1.
2. 0. 0. 1.
2.5 0. 0. 1.
3. 0. 0. 1.
5. 0. 0. 1.
6. 0. 0. 1.
7. 0. 0. 1.
8. 0. 0. 1.
9. 0. 0. 1.
9.5 0. 0. 1.
0.5 0. 0. 1.
Dennis Hodges
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected]<mailto:[email protected]>
Please note: e-mail may be subject to public disclosure.
From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker
Sent: Wednesday, May 28, 2014 12:17 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Adding Columns with zeros
Dennis
Is the column tothrs already in your view?
Buddy
From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On
Behalf Of Hodges, Dennis
Sent: Wednesday, May 28, 2014 12:05 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Adding Columns with zeros
All fields are double. Here is the result.
R>connect wdoss
Database Exists
R>show zero
(ZERO ) ON Treat nulls as ZERO in numeric calculations
R>browse realhrs, safhrs, callhrs, (realhrs + 0) as tothrs from t3t
R>Select realhrs, safhrs, callhrs, (realhrs + safhrs + callhrs) as tothrs from
t3append
realhrs safhrs callhrs tothrs
--------------- --------------- --------------- ---------------
8. 0. 0. 0.
10. 0. 0. 0.
7. 0. 0. 0.
7.25 0. 0. 0.
10. 0. 0. 0.
6.5 0. 0. 0.
8. 0. 0. 0.
1. 0. 0. 0.
2. 0. 0. 0.
2.5 0. 0. 0.
3. 0. 0. 0.
5. 0. 0. 0.
6. 0. 0. 0.
7. 0. 0. 0.
8. 0. 0. 0.
9. 0. 0. 0.
9.5 0. 0. 0.
0.5 0. 0. 0.
Dennis Hodges
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected]<mailto:[email protected]>
Please note: e-mail may be subject to public disclosure.
From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On
Behalf Of Javier Valencia
Sent: Wednesday, May 28, 2014 12:00 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Adding Columns with zeros
What type are the columns? To add they must not be TEXT.
Try the following and see if it works:
Select realhrs, safhrs, callhrs, (realhrs + safhrs + callhrs) as tothrs from
t3append
Now you should see the individual values and the sum.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On
Behalf Of Hodges, Dennis
Sent: Wednesday, May 28, 2014 10:16 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Adding Columns with zeros
I see the column, it just has zeros in each row.
Dennis Hodges
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected]<mailto:[email protected]>
Please note: e-mail may be subject to public disclosure.
From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On
Behalf Of Javier Valencia
Sent: Wednesday, May 28, 2014 11:12 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Adding Columns with zeros
Dennis,
I tried the same thing and it works fine for me . However, when you use the
SELECT command the columns display is limited by the display width and you
might not be seeing all the columns, since the computed column will show up at
the end (right) after all the other columns selected by "*" are dis[played.
Try using BROWSE instead of SELECT and see if all columns display correctly.
BROWSE *, (realhrs + safhrs + callhrs) as tothrs from t3append
Or simply change the order:
Select (realhrs + safhrs + callhrs) as tothrs, * from t3append
And now the computer column should show as the first column.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On
Behalf Of Hodges, Dennis
Sent: Wednesday, May 28, 2014 7:56 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Adding Columns with zeros
I have a view with production data that includes 3 columns for hours and I want
to create a total hours column. I previously converted null values on all
three columns using ifnull(realhrs,0,realhrs). The following gives me zeros
for tothrs:
Select *, (realhrs + safhrs + callhrs) as tothrs from t3append
Any help would be greatly appreciated.
Dennis Hodges
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected]<mailto:[email protected]>
Please note: e-mail may be subject to public disclosure.
