Maybe check your EQNULL setting. -----Original Message----- From: "Hodges, Dennis" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 28 May 2014 15:49:47 +0000 Subject: [RBASE-L] - RE: Adding Columns with zeros
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] [mailto:dennis.hodges%40dot.state.fl.us] Please note: e-mail may be subject to public disclosure. -----Original Message----- From: [email protected] [mailto:rbase-l%40rbase.com] [mailto:[email protected] [mailto:rbase-l%40rbase.com]] 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 [http://www.rbase.com/] www.facebook.com/rbase [http://www.facebook.com/rbase] -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
