InfoPath Dev

Hello,

I am attempting to set up a filter using xPath and a Secondary DataSource (no filter applied as of yet).

Dim DOM As Xml.XPath.XPathNavigator
Dim NI As System.Xml.XPath.XPathNodeIterator
Dim expr As XPathExpression

DOM = Me.DataSources("My_Secondary_DataSource").CreateNavigator
expr = DOM.Compile("/dfs:myFields/dfs:dataFields/dfs:My_Secondary_DataSource")
NI = DOM.Select(expr)

On the last line of code, I receive the error "Namespace Manager or XsltContext needed. This query has a prefix, variable, or user-defined function."  

If I change the last line of code to "NI = DOM.Select(expr, me.NameSpaceManager)", I get an error stating "Error 8 Value of type 'System.Xml.XPath.XPathExpression' cannot be converted to 'String'".

Any thoughts on how to fix this error?

Thanks in advance,

Pinback

Hi, Pinback and if you try:

NI = DOM.Select("/dfs:myFields/dfs:dataFields/dfs:My_Secondary_DataSource", me.NameSpaceManager)

Hello Potemkine :)

When I try:

NI = DOM.Select("/dfs:myFields/dfs:dataFields/dfs:"My_Secondary_DataSource"[Facility='Mary']", Me.NamespaceManager)

it reads the code, but the following line:

MsgBox(NI.Count)

returns a value of 0 despite the fact there are 4 instance of Mary in "My_Secondary_DataSource".

Hi, if  Facility is an attribute try this :

NI = DOM.Select("/dfs:myFields/dfs:dataFields/dfs:"My_Secondary_DataSource"[@Facility='Mary']", Me.NamespaceManager)

BINGO! :)

You did it, Potemkine! Thanks so much! :) :)

Pinback

You're Welcome Pinback :)