SQL Database Integration

Re: how to write the Xpath from connection

Greg Collins — Thu, 20 Jul 2006 18:26:02 GMT

Glad you got the issue resolved and that I was able to help out a bit.

Re: how to write the Xpath from connection

Whitley — Thu, 20 Jul 2006 01:13:35 GMT

hi,

done.
this is what am i refer to
http://blogs.msdn.com/infopath/archive/2004/09/13/228881.aspx
anyway, thanks for your idea.

Re: how to write the Xpath from connection

Greg Collins — Wed, 19 Jul 2006 16:26:47 GMT

According to the schema structure you showed, there should be no namespace prefix for tblStaff. That would make your selection as follows:

thisXDocument.DOM.selectSingleNode("//dfs:myFields/dfs:dataFields/tblStaff/@Designation").text

But if this doesn't work, then I suspect that there is a different namespace being used. You will need to find out what it is: (ns1:tblStaff, or something like that).

how to write the Xpath from connection

Whitley — Wed, 19 Jul 2006 09:40:41 GMT

i have set 2 tables for main connection which connect to my access database. then i am using vb.net to code the project now.

-myFields
-dataFields
-d:tblLeaveInfo
-Leave_ID(this is a Field Name)
-tblStaff
-StaffNo(this is a field name)

the xpath for main connection is
thisXDocument.DOM.selectSingleNode("//dfs:myFields/dfs:dataFields/d:tblLeaveInfo/@Leave_ID").text
*** main table for the connection is running correctly.

the second table for the main connection is
thisXDocument.DOM.selectSingleNode("//dfs:myFields/dfs:dataFields/d:tblStaff/@Designation").text
*** but second table for the main coneection got error message when i try to debug the program.

error message is

System.NullReferenceException
Object reference not set to an instance of an object.
at InfoPathProject3.InfoPathProject3.CTRLReset_OnClick(DocActionEvent e)
at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)