Using ChD and NoValue

[Simon_Aldworth]

Hi all,

The following line of code returns null even when the two data points are not NV. The syntax seems ok to me so what am I doing wrong?

If ChD(1, "Working/YDeadBandY") <> NV And ChD(2, "Working/YDeadBandY") <> NV Then

I know that I can use IsNull, but I'd still like to know what's wrong with the above line if possible.

Thanks,

Simon.

[MitchBrown · Accepted solution]

Hey Simon,

The reason that this test does not work is that within VBScript, a NoValue is converted to a NULL. As a NULL and a NoValue are not the same (for the purposes of this test), this is why the statement does not work.

For a concrete reference to this please see this Knowledgebase article.

Let me know if this answers this question for you!

MItch