Executing a stored procedure with OUTPUT parameters

re: Executing a stored procedure with OUTPUT parameters

Jimmy — Mon, 30 Nov 2009 05:32:08 GMT

Hey sasyregak,

Sorry for not responding to your post until now. I don't get notifications about comments on my blog posts and the easiest way to get a response is to open a new forum post.

It sounds like you are trying to use this technique on your main data source. InfoPath performs schema validation on the main data source and an operation like this that returns a schema other than the expected one will cause that error.

Might you be able to try this technique on a secondary data source?

Social comments and analytics for this post

uberVU - social comments — Fri, 30 Oct 2009 16:56:24 GMT

This post was mentioned on Twitter by InfoPathDev: Blog: Executing a stored procedure with OUTPUT parameters in InfoPath - http://su.pr/7WfE2W

re: Executing a stored procedure with OUTPUT parameters

sasyregak — Fri, 28 Aug 2009 13:02:54 GMT

Further after trouble shooting....I am able to find the output of the query in query analyser giving rise to a date value(single).

But the preview on infopath given the following error

The query cannot be run for the following DataObject: Report connection

The XML data returned from the data source does not match the XML Schema for this form. This discrepancy might be caused by the data source returning multiple rows when InfoPath expects only one.

Element '{schemas.microsoft.com/.../dataFields}row' is unexpected according to content model of parent element '{schemas.microsoft.com/.../dataFormSolution}dataFields'.

Expecting: {schemas.microsoft.com/.../dataFields}FileGeneralInfo.

Appreciate your help on this.....

re: Executing a stored procedure with OUTPUT parameters

sasyregak — Thu, 27 Aug 2009 12:46:04 GMT

Jimmy

Thanks for your tips... I was stuggling to get this achieved.

/ Get the default SQL command for the form.

var strOrigSQLCommand = XDocument.QueryAdapter.Command;

//Find the value of the filter criteria

var strInspectionValuationhistory = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/q:Inspection_Valuation_history");

var strvisit = strInspectionValuationhistory.selectSingleNode("@Which_visit").text;

strvisit = strvisit - 1; //store the previous visit value

if(strvisit != "")

{

strpreviousvisitSQLcommand = "DECLARE @Previousvisitdate datetime " + " EXECUTE test " + strvisit + " ,@Previousvisitdate OUTPUT " + " SELECT @Previousvisitdate as previousdate";

}

XDocument.UI.Alert(strpreviousvisitSQLcommand);

XDocument.QueryAdapter.Command = strpreviousvisitSQLcommand;

XDocument.Query();

//Here i need to get the result stored in a global variable , so that i can refer in any other view whereever required.......please guide me

XDocument.QueryAdapter.Command = strOrigSQLCommand;

XDocument.Query();