InfoPath 2013 Form with SQL Server Stored Procedure Call - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

InfoPath 2013 Form with SQL Server Stored Procedure Call

Last post 09-11-2013 04:06 PM by Kbirstein. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 09-11-2013 04:06 PM

    InfoPath 2013 Form with SQL Server Stored Procedure Call

    Hi, We have a simple test form that we are trying to retrieve data into from a SQL Server (2008 R2) Stored Procedure. The procedure is very simple--it takes two parameters (from text boxes on the form) and filters a view based on those two parameters. Let me just say that we have other forms with stored procedures that are working just fine. The code is on an After Change event (we have other After Change events working fine) and works fine in PREVIEW mode in InfoPath but doesn't return anything when running in the Browser after we publish to the server. We are getting the following error: Execution thrown from business logic event listener: The database returns an error. One of more rows contain values violating non-null, unique or foreign-key constraints. We don't believe we have any rows containing values that violate any constraints so we're at a loss as to why we are getting this error. Any ideas? Thanks, Kathryn
    Kathryn Birstein
    Senior SharePoint Architect and Developer
Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.