This is a vb.net managed code. I am getting an error "Object Reference
not Set" at Line 14 where I compare if cNode is Nothing.

What this Sub does is it takes the query parameter RCTID and does a
thisXDocument.Query(), after which I want to see (compare) if a node
was returned or not. If a valid node was returned then alls ok (do not
prompt), else prompt "ID not found in the database". I have trimmed
down this code, because there is additional processing I would like to
do after this, but have to resolve this issue before proceeding ahead.

There exists an RCTID=3 in the database, I enter 3 on the query
parameter RCTID within the infopath form, hit the BTN_SEARCH button,
and infopath returns all data related to RCTID=3, but it also complains
"Object Reference not set" at Line 14.

If returned then I am assuming cNode should not be empty, but it always
gives an error, no matter if a node is retrieved or not.

Any ideas why?

1
<InfoPathEventHandler(MatchPath:="BTN_SEARCH",EventType:=InfoPathEventType.OnClick)>
_
2 Public Sub BTN_SEARCH_OnClick(ByVal e As DocActionEvent)
3     ' Write your code here.
4     Try
5  Dim qcurrRCTID
=thisXDocument.DOM.selectSingleNode("//q:Main").attributes.getNamedItem("RCTID").text
7  If (qcurrRCTID = String.Empty) Then
8      Throw New Exception("Please enter a Transfer #")
9  ElseIf (Integer.Parse(qcurrRCTID) <= 0) Then
10      Throw New Exception("Please enter a Numeric ID")
11  Else
12      thisXDocument.Query()
13      Dim cNode As IXMLDOMNode
=thisXDocument.DOM.selectSingleNode("//d:Main/")
14      If cNode Is Nothing Then
15   Throw New Exception("ID not found in thedatabase")
16      End If
17  End If
18     Catch eX As Exception
19  thisXDocument.UI.Alert(eX.Message)
20     End Try
21 End Sub