Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Infopath error sumbitting data to SQL through SharePoint.

Posted on 2013-01-16
2
Medium Priority
?
765 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 2000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Screencast - Getting to Know the Pipeline

926 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