Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returned param value has no decimals
Message
 
To
28/01/2008 09:30:32
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01286059
Message ID:
01286197
Views:
28
>I am having a problem getting decimal values from a stored procedure. The SQL stored procedure works correctly in SQL Query Analyzer and prints a value of say 17.25.
>
>When I use the following in VB.NET the answer (param.value) returns 17D with no decimals.
>

Just a WAG, but try specifying the type when you create the output parameter:
Dim param2 As IDbDataParameter = Me.CreateParameter("@ItemSum", 0, DbType.Decimal)
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform