Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Returned param value has no decimals
Message
 
À
28/01/2008 09:30:32
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
01286059
Message ID:
01286197
Vues:
29
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform