InfoPath Dev

I am programming an InfoPath form which interacts with SharePoint to submit data to a list.  The form controls are all written in C# and using XML and CAML to submit data to the site.

The form is working accurately about 95% of the time.  The other 5% nothing gets updated to the form.

I am fairly certain the issue is happening when my CAML file is called.

all variables are strings and all fields in the SharePoint except DisputeReviewAttachment are single line text fields char limit 255.  The attachment field is a hyper link field that stores a link to a file uploaded to the sharepoint site.(the attachment will not allways have data)

so the forum dosnt like how I am entering my code, is there a recomended way for me to do that?

I struggle with getting my code to paste nicely in here as well - If I paste into Word, then into a Rich Text box in InfoPath, then into the forum, I succeed. I rarely bother with all that tho. :-)

So - when you submit, you can pass in some additional XPath Navigators to get some error info back, and submit passing those in - submitDataconnection.Excute(null, outputNav, errorNav) - then get error info back from those.... http://msdn.microsoft.com/en-us/library/office/aa943097.aspx for more - passing in null for the inputNav means the data connection will use whatever you set up when you initially set up the submit connection. You can check the errorNav with something like XPathNavigator errorNode = errorNav.SelectSingleNode("//*[local-name() = 'errorstring']"). The outputNav may also have errors in it - check for ErrorCode or ErrorText.

thank you so much for the quick response.

after reading the link you provided I think I am half understanding the recomendation, the idea is that I create a query connection to the fields I need to enter data to via an xml based web address connection. and using this rather than my CAML file i can submit the data and have a place to store the error message by creating an xpath to fields in my Main/myFields data source.

 Actually, I'm suggesting that you modify this:

DataConnections["CustomListItemsSubmit"].Execute();  

Create a web service connection instead and when you execute it you can pass in the output nav and errors nav to return any error info and track down the issue.

Edited to add: Like this:

WebServiceConnection shpSubmit = (WebServiceConnection) this.DataConnections["CustomListItemsSubmit"];

Then shpSubmit.Execute(null, outputnav, errorsnav);

 I was able to follow you up to shpSubmit.Execute(null, outputnav, errorsnav), but I am having trouble to retrieve the error text. Could you elaborate?

Thanks!

 Here's sample code:
http://msdn.microsoft.com/en-us/library/aa943097.aspx

Skip the part where they create a nav for the input, and pass null instead.

You'll find errors either in the errors nav or the output nav - run in debug to examine the results of those.

 Yes, I see "0x81020054The user does not exist or is not unique." in outputNav.TypedValue and in Outputnav.OuterXml.Errortext, but I don't know how to access these fields.

outputNav.SelectSingleNode("TypedValue", NamespaceManager).Value does not work, returns NullReferenceException.

Any help you can give would be much appreciated!

 Never mind, I figured it out. I can just use outputNav.TypedValue.ToString()

Thank you!