Andrew2009 Well Known Member Jun 7, 2017 #1 Does this code check for Null and Blank? If PO cProcessedRevRec_EV01 [EV01] is less than or equal to <Blank>
Does this code check for Null and Blank? If PO cProcessedRevRec_EV01 [EV01] is less than or equal to <Blank>
johndanter Legendary Poster Jun 8, 2017 #2 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. Last edited: Jun 8, 2017
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.
Larry_Jones Legendary Poster Jun 12, 2017 #3 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.
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.
Chan Rana Legendary Poster Jun 13, 2017 #4 I haven't tried too but I would use C function to evaluate if need be. Chan