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]] 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 <mailto:[email protected]> [email protected] Please note: e-mail may be subject to public disclosure. From: [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]] 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 <mailto:[email protected]> [email protected] Please note: e-mail may be subject to public disclosure.
