InfoPath Dev

Thanks Greg

Changed to using GetDom("HolidayCalendar") instead of DataObjects("HolidayCalendar").DOM but still getting an object required error when using selectSingleNode?  I don't know why I can't get data into a variable from a secondard data source - it's frustrating and mystifying.

I've tried putting the field on the form and seen it update with the first row in the table, but still getting an object required error.

Either I am doing something wrong or infopath doesn't allow this? 

1. Verify that uCalendarDataSource is actually a valid object.
2. Get just the object without trying to access the .text property:
   uHolidayDate = uCalendarDataSource.selectSingleNode("/dfs:myFields/dfs:dataFields/d:HolidayCalendar/@BankHolidayDate")
3. Check whether uHolidayDate is a valid object.

My guess is that uHolidayDate is not valid because something is not right in the XPath.

Thanks again Greg.

I am suspecting that this might be a lack of understanding on my part of namespaces for secondary data sources.  I have set the SelectionNamespaces to the same as the main data source.  See code below:

XDocument.DOM.setProperty "SelectionNamespaces", "xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:q=""http://schemas.microsoft.com/office/infopath/2003/ado/queryFields"" xmlns:d=""http://schemas.microsoft.com/office/infopath/2003/ado/dataFields"" xmlns:dfs=""http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"" xmlns:my=""http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-06-06T12:26:30"" xmlns:xd=""http://schemas.microsoft.com/office/infopath/2003"""

XDocument.GetDOM("HolidayCalendar").setProperty "SelectionNamespaces", "xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:q=""http://schemas.microsoft.com/office/infopath/2003/ado/queryFields"" xmlns:d=""http://schemas.microsoft.com/office/infopath/2003/ado/dataFields"" xmlns:dfs=""http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"" xmlns:my=""http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-06-06T12:26:30"" xmlns:xd=""http://schemas.microsoft.com/office/infopath/2003"""

The Data Source Window shows the following:

 - myFields

       - dataFields

             - d:HolidayCalendar

                 :ID

                 :BankHolidayDate

Have I got something wrong?  When I click on the details of the data sources, the namespace information is the same as the main data source.

I only seem to be able to access data that is stored in the main data source.

Any help is much appreciated.

The data source task pane unfortunately does not show all the namespaces. If you are using InfoPath 2007, a useful new feature I requested was implemented by the IP dev team which allows you to right-click on the field of interest and copy the complete XPath to that field to the clipboard. If you are using InfoPath 2003, then you should extract your form files, open the HolidayCalendar.xml file with a text editor, and disect that to pull out the appropriate namespaces for each node in your XPath.

Using the full set of namespaces from the main DOM is good as it will ensure that you are totally covered since it incorporates all namespaces for every DOM in the form template.

Thanks for your persistance Greg.

The namespaces are OK.  I've tracked it down to my modified SQL command for the secondary data source.  I am attempting to select on a date incorrectly somehow and this is causing the DOM to become invalid.  If I select manually on the ID (numeric) field in the SQL, everything is OK.

I will endeavor to discover how infopath wants the SQL where clause to look when selecting a date on a date column.