Solved

Infopath error sumbitting data to SQL through SharePoint.

Posted on 2013-01-16
2
752 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now