InfoPath Dev

Hi

I am trying to update a field in my Forms library. It works fine, do not give any error but does not update the field. I am also an administrator on the server with full access This is my code :

using (SPSite site = new SPSite("http://server:10746"))
               
                {
                    using (SPWeb web = site.OpenWeb())
                    {
                        SPList surveylist = web.Lists[<Forms Library>];
                   
                        //Name of the field as in list settings
                        string ColumnName = GetInternalName("Location Sequence", surveylist);

                        string camlQuery = "<Where><Eq><FieldRef Name='" + ColumnName  + "'/><Value Type='Integer'>"+ currentLocationSequence +"</Value></Eq></Where>";

                        SPQuery sharepointQuery = new SPQuery();
                        sharepointQuery.Query = camlQuery;
                        SPListItemCollection surveys = surveylist.GetItems(sharepointQuery);

                        foreach (SPListItem survey in surveys)
                        {
                            survey["Survey Status"] = 7;
                            survey.Update();
                            //surveylist.Update();
                        }

                    }
         }

This code works fine without any error but does not update the value.

Any suggestion or help is appreciated

 Hi,

As I am using a Forms Library and try to change the value of a promoted property column, I also tried 

survey.Properties["{94c0bb55-0e52-4133-b242-882b2443de6c}"] = 7;

in the above code but still no luck.

Hello,

Check out this link,

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splistitemcollection.aspx

 Thnaks Shiva !

I am also doing the same thing as in the link u reffered. I think its a limitation with promotion properties in an infopath forms library because when I try to update the any column which is not promoted column, same code works fine.

Seems some error or limitation with Forms Library in MOSS.

 

Hello,

Thank for your reply. Did you exceed the limitation of promoted list properties in your form? Can you give more detail on your error message?Hello,

Go through the below link to get more information on Xdocument,

http://msdn.microsoft.com/en-us/library/bb229879.aspx

Hi,

As of my knowledge there is a limit for the promoted properties in the SharePoint library. I do not know the exact number but it will accept around 75 to 80 columns.