The data source control failed to execute the update command – Finally a solution
// April 30th, 2009 // Uncategorized
I have literally google the h*ll out of this one. As someone that plays with a lot of dataviews and custom list forms, i come across it this one and im hoping this blog post helps a lot of people!
Essentially the history around it is that it is a Date related problem. So on your Form, if you have Date related fields and you hit the save button, you will get the error which is specified. Apparently the hotfix for kb 949749 works, although some say it doesnt. From readking it may have something to do with the date format and using MM/DD/YYYY and DD/MM/YYYY. Either way, i havent been able to find any quick fixes for it…. until yesterday!
And its really quite simple, although probably not the best solution, it still works.
1. Open up Sharepoint designer, and fire up the problem page.
2. In the design view, find all the date fields. Click the > button as shown below
3. Change the dropdown from List Form Field to Date Picker Field.
Do you have any advice on the same topic if the data type is actually a user?
I have a custom entry form. The column type in the sharepoint list is “Person or Group”, I’m using a FormField formatted as a ListFormField in sharepoint designer. The form renders in IE correctly – I can fill out the user name and “check” the names without trouble, but when I click OK to save I get the same error “The data source control failed to execute the update command.” I know this column is the culprit because I can remove it and use the form without error (and without storing anything to this column of the list) I’m using SP Designer SP2 and Moss2007.
I should note – I tried changing the input field to a text box with no luck.