Carlos, Am working with your "most excellent" FirebirdClient 2.0 in VS
2005.
Don't know if this is the right place, but if it is, thought I'd pass on
an experience.
We have an older Delphi 5 application that runs an older Firebird db
(was IB) dialect 1. The db has a number of parameterized 'SELECT'
stored procs that are called in Delphi with good results. The one in
the code below should return a singleton answer "SUM(QTY)".
Was trying to test your new provider with sample code (like below) from
many sites and was failing to get a result. Thought it was my lack of
understanding of syntax.
After getting very frustrated, tried the proc call in IBOConsole and it
returned <null>! Rewrote the proc with FOR..DO..SUSPEND syntax, which I
normally use, and the code below started working like a champ.
If anyone has trouble with the SELECT's, first order of business is
testing in IBOConsole. If that doesn't work the code never will! The
Delphi 5 app still works fine as well.
Thank you for your work!
-Craig
Code:
-----------------------------------------
int itemId = 263;
decimal qty;
FbCommand fbCommand = new FbCommand("SELECT * FROM
GET_ITEM_QTYSUM(@ITEMID, fbConnection);
fbCommandType = System.Data.CommandType.StoredProcedure;
fbCommand.Parameters.AddWithValue("@ITEMID", itemId);
fbCommand.Connection.Open();
FbDataReader qtyData = fbCommand.ExecuteReader();
if (qtyData.Read())
{
qty = qtyData.GetDecimal(0);
}
else
{
qty = 0;
}
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
