On Submit I need not only to add an item to the Library but also to add one item to the List1 and multiple items to the List2
I use 2 CAMLs and 2 web service connections (having 2 fields on the form with lists' GUIDs). Something like this -
Dim batch1 As XPathNavigator = DataSources("CamlAddToItemDetails").CreateNavigator()batch1.SelectSingleNode("/Batch/Method/Field[@Name='ItemId']", NamespaceManager).SetValue(ItemId)batch1.SelectSingleNode("/Batch/Method/Field[@Name='Commodity']", NamespaceManager).SetValue(Commod)DataConnections("WebServiceSubmitToItemDetails").Execute() ‘Loop to Add multiple rows to the second list While (condition)'Get vars step, stepOrder, etcDim batch2 As XPathNavigator = DataSources("CamlAddToItemSteps").CreateNavigator()batch2.SelectSingleNode("/Batch/Method/Field[@Name='ItemId']", NamespaceManager).SetValue(ItemId)batch2.SelectSingleNode("/Batch/Method/Field[@Name='Step']", NamespaceManager).SetValue(step)batch2.SelectSingleNode("/Batch/Method/Field[@Name='StepOrder']", NamespaceManager).SetValue(stepOrder) MessageBox.Show(vars to add) DataConnections("WebServiceSubmitToItemSteps").Execute()End While
Items in the first list are created with no problem and the second CAML fails to add but I don't get any error messages. What could that be?