Solved

Infopath error sumbitting data to SQL through SharePoint.

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

838 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