InfoPath Dev

I can't because the outer implicit transaction definition will cause the inner transaction to be rolled back.

Yes, It doesn't save the data. It always puts rollback after stored procedure call.

Thanks for clarification. When I publish the form on sharepoint and fill it, clicking on save button (uses the code specified above), will put implicit transaction before and rollback after stored procedure call.

Sorry, I don't know what do you refer to as "IP Query" and can't find any similarity between my case and the one in your posting.

I use something like the following code when I need to save data fields on SQL Server: XDocument.QueryAdapter.Command = "exec dbo.SaveSQLComplexDBinfo " + SQLComplexDBID + ",'" + ComplexName + "','" + DBName + "','" + AppCode + "'"; XDocument.Query(); When I check ...

Any feedback? I use something like the following code when I need to save data fields on SQL Server: XDocument.QueryAdapter.Command = "exec dbo.SaveSQLComplexDBinfo " + SQLComplexDBID + ",'" + ComplexName + "','" + DBName + "','" + AppCode + "'"; XDocument.Query(); When ...

Hi, How can I get rid of begin transaction and rollback that Infopath puts around any data change I have in user interface preview form? I would like to be able to test my form.  Thank Ali

Hi All, I have a repeating table consisting of two columns (contact name and contact type). I would like to be able to update and delete individual rows of this table. Therefore, I added two buttons per row for Save and Delete and use the below code to delete, for example. The problem is that AppContactID always receives value from the first ...

Thanks. That did it. Sorry one more question: After clicking on insert item in repeating section, how do I actually save new values in SQL Server? How do I access data fields entered by user?  

I am getting 'source' is null or not an object. Here is my code: function btnItemDelete::OnClick(eventObj) { var AppContactID = eventObj.source.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SQLComplexDBList/@AppContactID").text; Any idea why? Thanks