Code

Re: @RETURN_VALUE from stored procedure

bobstery — Fri, 14 Oct 2005 07:24:26 GMT

That doesn't give an example of receiving parameters from stored procedures.

I just get an error stating that Command.Parameters is invalid.

Re: @RETURN_VALUE from stored procedure

franck — Fri, 14 Oct 2005 01:24:55 GMT

Hi,

Have you checked:http://support.microsoft.com/?kbid=827007

Hope that it helps.

Regards,

Franck Dauché

@RETURN_VALUE from stored procedure

bobstery — Thu, 13 Oct 2005 13:17:48 GMT

I have the following code below, however I cannot access the @RETURN_VALUE of the stored procedure, any ideas:

XDocument.QueryAdapter.Command.Parameters.Append(XDocument.QueryAdapter.Command.CreateParameter("@RETURN_VALUE",3,4));

XDocument.QueryAdapter.Command = "execute createPickup '" + driverName + "','" + registration + "'";

XDocument.Query();

XDocument.UI.Alert(XDocument.QueryAdapter.Command.Parameters("@RETURN_VALUE").text);

Many Thanks