InfoPath Dev

Hi,

Here is the selectSingleNode statement producing an error ("Object required")

XDocument.UI.Alert(XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:BC_Verification[@BC_ID = my:myFields/my:user]/@Name").text);

Where 'dfs' and 'd' are the namespaces of the secondary data source, and 'my' for the primary source.

BC_Verification attributes:

1. BC_ID
2. Name 

'user' is a pre-filled field in the form being used to filter a BC_Verification entry where BC_ID = user. Any ideas on what's giving the error?

Erich

This can be done fairly simply with rules and such, but in code it's not possible to have a single XPath reference two data sources.

You could first get the my:user value and concatenate it into another XPath, but the JScript syntax for accessing a 2DS is somewhat involved.  Is there some reason you can't use a rule to show this alert?

Yes, what I would like is to store the value of the 'Name' attribute from the secondary data source as a global variable. My problem is that it appears script is executed before rules are, so when I try to extract the 'Name' attribute from a rule-calculated field, it returns an empty string since the rule has not yet been applied.

Erich