Hello,
I am having trouble with the decimal type:
FbParameter[] parameters =
{new FbParameter("@CartId" ,FbDbType.Integer ,0)
,new FbParameter("@CustId" ,FbDbType.Integer ,0)
,new FbParameter("@UseAltShipAddress" ,FbDbType.Integer ,0)
,new FbParameter("@ShipCost" ,FbDbType.Integer ,0)
,new FbParameter("@ShipWeight" ,FbDbType.Decimal)
etc
Then I add this:
parameters[ 4].Precision = 8;
parameters[ 4].Scale = 2;
parameters[ 4].Value = ShipWeight;
Using this, the insert fails with this message:
"The string was not recognized as a valid DateTime. There is a unknown
word starting at index 0"
Of course, it is not a DateTime problem. If I remove the decimal parameter
the insert works fine. However the last field _is_ a DateTime, so the only
thing I can guess is that the decimal parameter is not added, and that
sets the count of parameters off.
I'm sure I am missing something, but I have searched high and low, and
cannot find what i am doing wrong.
Thanks,
Kyle
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
