-
The reason I'm suggesting this is so you know exactly what data is being returned to the form. By adding the data fields onto the form and previewing, you can see the values - but the checkbox control could be hiding something... like blank values.
-
I guess I'm not explaining well. Don't change your SharePoint list. Simply right click the Check Box in InfoPath and change to text. I'll post some screnshots in a minute.
-
Did you try changing that checkbox control to a text box like I suggested? So when you preview you can see the actual values?
-
In your new data connection, you should see query fields and data fields. You can set a query field in the list to a value (in this case it will be this URL value that you submitted to the list originally) and then query for data - here's a blog post with some info: ...
-
Silly form. Drag the field contracts data fields onto the form and make sure the control for Deactivated is a text box so you can see the actual value and preview - is it really false? Or maybe blank and we need to use not equal to true?
-
Okay. You had said the column was a URL. :) I thought you meant the column type was a hyperlink.
You should be able to:Add a data connection to the list you are submitting data toInclude the URL column and the ID column in the data connectionDon't query for data on loadIn the form, set the query URL field in the new ...
-
The reason I posted a link to a code sample is that it has a nice sample CAML batch in the code - simply meant to show you the correct CAML syntax. If you include the proper method and the <Field Name="ID">YOURIDNUMBERHERE</Field> in your CAML batch, and submit that CAML to the UpdateListItems web service (along with ...
-
The only way to update is by using the SharePoint List Item ID. I figured based on the title of your post you were already using CAML and the UpdateListItems web service? There are lots of posts on here about doing this. This thread is a pretty good one: http://www.infopathdev.com/forums/t/26246.aspx?PageIndex=1
-
What are the results you are getting with the filter you have added? Do any contracts show?
-
For updates, your CAML needs to include the SharePoint List Item ID for the item. So, if you add the ID column to your view in SharePoint, you can see that.... if you have a data connection to your list in InfoPath you can include this ID column as well.
<Field Name="ID">2</Field>
The sample code found here shows ...