Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Delete SQL Record from a SharePoint Form Delete

  Asked By: Johnpaul    Date: Mar 17    Category: Sharepoint    Views: 1574

I was wondering if you might have heard this before. I am performing
a dual post on my InfoPath form

1) SharePoint
2) Web Service to SQL DB Relational Database for SQL Reporting

The Web Service is used because of the complex InfoPath form with
repeating items and also the need for some robust reporting. The
INSERT and UPDATE for the form works great. However, I have a real
problem if the InfoPath form is deleted from the Forms Library. My
data in the Database will not be deleted because end user is actually
not in InfoPath to delete the form, but rather in SharePoint. Do you
know of a way or have resources that can help in know how to ensure
the DB record will be deleted from the SharePoint delete?

The DB will use cascade delete to delete 15 tables worth of data. If
a simple DELETE FROM SummaryTABLE WHERE SumID = ???

However, I have to have some way to trigger that Stored Proc and pass
the SumID.



2 Answers Found

Answer #1    Answered By: Rose Silva     Answered On: Mar 17

This will require custom programming, and can be done either via a
custom workflow or a delete  event handler attached to items  in the Form

Answer #2    Answered By: Maegan Ellison     Answered On: Mar 17

Would an Event Receiver do what you need?

Didn't find what you were looking for? Find more on Delete SQL Record from a SharePoint Form Delete Or get search suggestion and latest updates.