I've figured out how to use FBConnect to call ExecuteScalar() to retrieve a
singe output parameter from a stored procedure that returns only one value,
like this:
FbCommand cmd = new FbCommand("PREDICT_COST_1");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BARCODE", barcode);
cmd.Parameters.Add("@STOREID", storeid);
using (cmd.Connection = new FbConnection(ConnString))
{
cmd.Connection.Open();
var result = cmd.ExecuteScalar();
thecost = Convert.ToDouble(result);
}
I also have a stored procedure defined as follows:
create procedure PRODUCT_OUT_1
(BARCODE VarChar(25), QTY Double Precision, QTY_IS_DIFF Char(1))
returns (NEW_QTY Double Precision, AVG_COST Double Precision)
as
...
How would I call the above SP and retrieve both the values of NEW_QTY and
AVG_COST?
-Joe
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
