I could be wrong, but I don't think a numeric variable can be set to null. Display the value of the variable just after you set it to null. I' m betting it will be 0 at that point.
Phillip Cecil Rbase developer WCAA ________________________________ From: Ken Shapiro <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sunday, February 23, 2014 11:25 AM Subject: [RBASE-L] - RE: Printing a report changes NULL variables to 0 Hi Larry, I tried this and could not replicate this issue. RBASE seems to “work as designed”. Ken From:[email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Friday, February 21, 2014 5:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Printing a report changes NULL variables to 0 Client just upgraded to 9.5 (latest version). Running the following program indicates that printing a report (any one, it doesn't matter) changes the values of numerical variables from NULL to 0: SET VAR fZT_Float INT = NULL WRITE "Old =", .fZT_Float PRINT CustomerParts WHERE LIMIT = 1 WRITE "New =", .fZT_Float RETURN Gives the following results: Old = New = 0 I tried with INT, REAL, and DOUBLE. I also tried with NULL set to ' ' and to '-0-'. I tried with SET ZERO ON and SET ZERO OFF, and SET EQNULL ON and SET EQNULL OFF. No matter what I do, my NULL values are overwritten with 0. The variable (in this case fZT_Float) is not involved in the report in any way, shape, or form. Is there some setting I'm missing? -- Larry
