Code

Re: Data Connection using Code

aehicks — Tue, 05 Jun 2007 21:04:10 GMT

You were correct. Once I changed the Query() to Submit() it worked perfectly. Thanks for your help.

Re: Data Connection using Code

davidair — Tue, 05 Jun 2007 20:42:37 GMT

Are you sure you didn't misspell it? You code looks correct but the error says"DataAdaters" with a "p" missing :)

Also, to submit, you want to call .Submit() and not .Query()

You can read this for more details: http://msdn2.microsoft.com/en-us/library/bb229877.aspx

Good luck!

Re: Data Connection using Code

aehicks — Tue, 05 Jun 2007 20:19:48 GMT

Thanks for your help. However, being new to InfoPath, I'm not really sure how to make the OnLoad handler work. Let me explain more on how I was to use it. I've written some code to run when the user clicks on the submit button. On of the final lines of code will call a data connection called "submit". I wrote the following code:

XDocument.DataAdapters("submit").Query()

When I tested it, I got the following error: ""Object doesn't support this property or method: 'XDocument.DataAdaters'". Again, I know nothing about data adapters, so if someone could help me with the correct syntax I would appreciate it.

Thanks.

Re: Data Connection using Code

davidair — Sat, 02 Jun 2007 02:30:40 GMT

Well, in general, using the InfoPath OM is the same in both JScript and VBScript...

Here is an example of an OnLoad handler which queries a web service (assuming you have added "TestConnection" ws adapter in InfoPath Designer):

Sub XDocument_OnLoad(eventObj)

XDocument.DataAdapters("TestConnection").Query()

End Sub

In general, here is a good reference if you need to find out what objects exist and what the parameters are:

http://msdn2.microsoft.com/en-us/library/bb230145.aspx

Hope this helps.

Re: Data Connection using Code

Patrick Halstead — Fri, 01 Jun 2007 22:38:26 GMT

Hi Aehicks andwelcome to the forum,

Unfortunately, we don't do any VBScript coding. We recommend .NET, but we could give you some help with JS if you were using that.

Data Connection using Code

aehicks — Thu, 31 May 2007 15:18:57 GMT

Does anyone know how to use VBScript code to invoke a data connection?