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
