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.
