Solved

Infopath error sumbitting data to SQL through SharePoint.

Posted on 2013-01-16
2
758 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

688 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