Re: Need the ID back for a successful submitted Web Service InfoPath Form????

Matt Faus — Thu, 03 Jan 2008 16:59:30 GMT

Hi moojjoo and sorry for the late reply!

Yes, you can get the returned ID. I assume you are using a "Submit" data connection in InfoPath, which makes it impossible to see the return statement unless you are using code to submit the data connection. If you want to add code, look at the .OutputLocation property on the WebServiceAdapter2 class.

Otherwise, you can convert your data connection to a "Receive" data connection (the first question in the data connection wizard), populate the queryFields with the appropriate information, and then the return ID will be underneath the dataFields node once the query has been issued.

The two data connections work exactly the same under the covers of InfoPath, but they are just handled a little differently by the designer and allow you to do different things with them.

Good luck!

Need the ID back for a successful submitted Web Service InfoPath Form????

moojjoo — Fri, 07 Dec 2007 17:18:12 GMT

Instead of using xml navigation I am utilizing a class that was created after running xsd.exe. Great tool and makes coding a lot quicker due to intellsense.

However, submitting the data into the DB is not a problem, but for the world of me although I have the following:

public int SubmitForm(myFields newForm, class blah)

{CODE to INSERT RECORD and GET sumID from stored procedure via the @@IDENTITY }return sumID

I don’t know how to populate a field after the submit in the XML file (InfoPath) so the next time if the field has a value I know to perform an update on the record based on the sumID.

Once I get that trick firgured out I would love to know how to automate a delete if a user deletes the file from the SharePoint library. I have the DB well built so if I run T-SQL on the sumID the record will cascade and delete all other child records.

I am close to finishing this solution and was wondering if anybody had done this.

Web Services

Re: Need the ID back for a successful submitted Web Service InfoPath Form????

Need the ID back for a successful submitted Web Service InfoPath Form????