Zero is set to on. I shouldn't have any nulls since I used IFNULL(val,0,val) to convert nulls to zero.
Dennis Hodges Maintenance Management Manager FDOT Office of Maintenance MS #52 PH: (850) 410-5635 FAX: (850) 410-5511 [email protected] Please note: e-mail may be subject to public disclosure. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, May 28, 2014 11:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Adding Columns with zeros At 11:16 AM 5/28/2014, Hodges, Dennis wrote: >I see the column, it just has zeros in each row. What are the database settings for ZERO? Set it to ON, and see what you observe. CONNECT dbname At the R> Prompt: SHOW ZERO Try the following quick test using the sample RRBYW18 database: CONNECT RRBYW18 BROWSE *,(Price*Units) AS MyCalculatedColumn FROM InvoiceDetail Notice the calculated results for MyCalculatedColumn. That should provide you with some blue's clues ... Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
