Solved

Infopath error sumbitting data to SQL through SharePoint.

Posted on 2013-01-16
2
754 Views
Last Modified: 2013-01-17
Ok my enviroment is as follows -

SharePoint 2010 platform up and running

SQL server platform with custom databases on a seperate machine

Situation.

I  need to use SharePoint as the front-end access to my SQL DB.

I have established serveral external lists that are working well with Infopath 2010 forms for several views that consist of a single table select query.

Probelm.

I have now been asked to handle a project of updating fields in a view that contains fields from multiple base tables. I need to update information that is in a single table however it is linked in the view to an Employee table using an EmployeeID and displaying FirstName LastName etc, about the employee in the list view of the External List. It seems that Infopath errors when sumbitting the data because it is trying to update all the fields of the External List which is on multiple tables. Is there a way to make Infopath only submit the few fields that I am actually updating in this application without erroring itself out trying to submit to the Employee table as well or is there a better way to go about getting the connection to SharePoint configured to handle submitting to multiple tables?

I have done a few days of Googling without much luck. Can anyone point me in a direction that can either solve this problem or help me ask the right questions?
0
Comment
Question by:CooperRiis
2 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 38784834
So you are using BCS in SharePoint to link to the SQL tables?

Often what you need to do is have your current view of the data for the user to view but then have component views behind the scenes that are able to do the update.

When they select submit you would then copy the data from the consolidated list to each of the sub views and then submit each of them.

Not sure how easy that is to do with SP lists.  you have some limitations in functionality with list forms compared to if you were using InfoPath directly with SQL.

To do enterprise type applications like you are describing that is really the way to go, have web services directly to the SQL.  Host the file in SP for the user but go direct with the data.

you may want to check out www.qdabra.com, they have packaged web services that do it all for you.
0
 

Author Closing Comment

by:CooperRiis
ID: 38786991
I was very afraid this would be the answer. For the time being I will build a single table that holds all the fields that I need in my application with triggers to update the actual table data.


I will look more into Webservices for SQL directly when I am given time to slow down between projects. Thank you very much for you post.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question