Yes, that solved the problem. Thank you.Patti
From: Albert Berry <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Monday, January 12, 2015 9:53 PM
Subject: [RBASE-L] - Re: Zero ON doesn't seem to be working right
SET ZERO ON tells R:Base to treat no data (null) as zero in numeric
calculations. The setting you need is
SET EQNULL ON/OFF
NULL <> NULL will only work if EQNULL is set ON
IDP12MA <> 1 will fail when IDP12MA IS NULL unless EQNULL is ON
Albert
On 1/12/2015 1:33 PM, Patti Jakusz wrote:
I have a command file with a "select" command that is coming up with no
records, even though there is one record out there that fits all the criteria.
Zero is set on
My data record has fields INADATE = '12/19/14' IDP12MA is null IDP14PHI = 0
My command is: select * from TABLENAME whe IDP12MA <> 1 and IDP14PHI <> 1 and
INADATE between '12/01/14' and '12/31/14'
The only way it works is if I add another selection criteria: select * from
TABLENAME whe (IDP12MA <> 1 or IDP12MA is null) and IDP14PHI <> 1 and INADATE
between '12/01/14' and '12/31/14'
Why do I have to add that if Zero is set on?
Thanks, Patti
--
A democracy ..." can only exist until the majority discovers it can vote itself
largess out of the public treasury."
Attributed to Alexander Fraser Tytler 1747-1813
