Andrew2009
Well Known Member
Does this code check for Null and Blank?
If PO cProcessedRevRec_EV01 [EV01] is less than or equal to <Blank>
If PO cProcessedRevRec_EV01 [EV01] is less than or equal to <Blank>
johndanter
Legendary Poster
Yes mate
Look at this ASCII chart as that's what it boils down to at the end of the day in the 2 CPU registers that ask the question
Space is 20 HEX
NULL is 0 HEX (less than blank)
ZERO is 30 HEX (so it's greater than blank)
http://www.asciitable.com/
PS: This chart has been printed out and as been up on my desk everywhere I've worked for the last 20 years as I keep forgetting.
Look at this ASCII chart as that's what it boils down to at the end of the day in the 2 CPU registers that ask the question
Space is 20 HEX
NULL is 0 HEX (less than blank)
ZERO is 30 HEX (so it's greater than blank
)http://www.asciitable.com/
PS: This chart has been printed out and as been up on my desk everywhere I've worked for the last 20 years as I keep forgetting.
Last edited:
Larry_Jones
Legendary Poster
It depends John.
I think Andrew was asking how JDE's ER handles nulls in a comparison.
For example Standard SQL treats NULL values as having no value. A comparison in SQL (and some other languages) returns NULL rather than True or False.
I suspect that JDE ER automatically does NULL conversions to a not-null low value but I've never coded that assumption.
I think Andrew was asking how JDE's ER handles nulls in a comparison.
For example Standard SQL treats NULL values as having no value. A comparison in SQL (and some other languages) returns NULL rather than True or False.
I suspect that JDE ER automatically does NULL conversions to a not-null low value but I've never coded that assumption.
Chan Rana
Legendary Poster
I haven't tried too but I would use C function to evaluate if need be.
Chan
Chan
