Newbie Questions

Re: Accessing dataObject outputs and controls programmatically

Hilary Stoupa — Tue, 29 Mar 2011 21:15:23 GMT

The oldest version of IP I have installed is IP 2007, SP 2, I'm afraid. In IP 2007, SP 2, I can use the following:

set dataObj = XDocument.DataObjects("GetDatePlusDays").QueryAdapter

With the name of my own data connection instead of "GetDatePlusDays", of course. Hopefully someone with IP 2003 SP 1 will be able to chime in.

Re: Accessing dataObject outputs and controls programmatically

pamam — Tue, 29 Mar 2011 19:38:22 GMT

Hilary,

In my world that does not work. This works

set dataObj = XDocument.DataObjects("GetDatePlusDays")

but

set dataObj = XDocument.DataObjects("GetDatePlusDays").QueryAdapter

does not work. I always get an error of "object does not supported property or method"

I can see it in the DOM but the compiler in InfoPath does not see it. could I need another service pace or something. I'm running into this with other objects as well.

Re: Accessing dataObject outputs and controls programmatically

Hilary Stoupa — Tue, 29 Mar 2011 18:04:29 GMT

You'll see from the MSDN link I referenced that:

For secondary data sources, the WebServiceAdapter object is accessible through the QueryAdapter property of the DataObject object, and DataObject objects are accessible through the DataObjects property of the XDocument object.

The code sample shows that you'd want:

set dataObj = XDocument.DataObjects("GetDatePlusDays").QueryAdapter

I don't see a Connection property in MSDN? But I do see a Name property -- so you should be able to get the name with:

dataObj.Name

Re: Accessing dataObject outputs and controls programmatically

pamam — Tue, 29 Mar 2011 16:39:26 GMT

Thanks Hilary, that was very informative. I had no idea that these options were available.

****

set dataObj = XDocument.DataObjects("GetDatePlusDays")

XDocument.UI.Alert( "DataObjects Connection: " & dataObj.WebServiceAdapter.Connection.Name )

****

The GetDatePlusDays is a webservice secondary datasource. The only adpater that seems to work is Adpater.

The actual error message is the the object does not support this property or method.

Thanks,

Mel

Re: Accessing dataObject outputs and controls programmatically

Hilary Stoupa — Tue, 29 Mar 2011 16:24:53 GMT

Hi and welcome --

It would be helpful to know what version of InfoPath you are using. For 2007 and above, you can right click a field or group in the data source task pane and select "Copy XPath" to get the XPath to a node.

According to MSDN, the WebServiceAdapter has been with us since IP 2003. The line of code you get the error on may help us help you debug it.

If you save your form as source files, you can look at the sampledata.xml file to see the namespace prefixes for your different data sources (if you are using IP 2003 and don't have the Copy XPath functionality). You can also find the XPath to fields using the formula editor (click the box that says "Edit XPath" to display the full XPath).

Accessing dataObject outputs and controls programmatically

pamam — Tue, 29 Mar 2011 16:15:58 GMT

My system is Infopath 2003 SP1? Windows XP SP3 in conjuction with SharePoint; however I just now working with InfoPath separately.

It is difficult to find out what the XPath is for a control or dataObject input or output.

I also noticed that some of the DataObject Adapters are not available. When I try to use WebServiceAdapter I get a syntax error "not supported object" or something to that affect.

Knowing what prefixes to use on the XPath would be a great help.

I would appreciate any help.

Mel