Hello:
> FbCommand fbCommand = new FbCommand("SELECT * FROM
> GET_ITEM_QTYSUM(@ITEMID, fbConnection);
>
This looks to be incorrect, hope it's:
FbCommand fbCommand = new FbCommand("SELECT * FROM GET_ITEM_QTYSUM(@ITEMID)",
fbConnection);
> fbCommandType = System.Data.CommandType.StoredProcedure;
>
If you are trying to set the CommandType ( this code isn't doing so but
to be sure )
to StoredProcedure it isn't needed as you are trying to run a SELECT query.
> fbCommand.Parameters.AddWithValue("@ITEMID", itemId);
>
Can you check that the parameter gets added correctly, please ??
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.blogspot.com/
No hay un solo rey que no descienda de un esclavo,
ni un esclavo que no haya tenido reyes en su familia.
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
