[Mono-bugs] [Bug 595918] Decimal parameter stored incorrectly from sql stored procedure

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Mon Apr 12 18:17:44 EDT 2010



jeevan kodali <kjeevan_kumar at yahoo.com> changed:

           What    |Removed                     |Added
                 CC|                            |kjeevan_kumar at yahoo.com
           Platform|Other                       |32bit
         OS/Version|Other                       |Linux

--- Comment #2 from jeevan kodali <kjeevan_kumar at yahoo.com> 2010-04-12 22:17:43 UTC ---
Sorry, probably you need exact code to replicate this bug, here it is, I am
using .Net 2.0 and running it on Linux machine connecting to Sql Server 2005:

SqlCommand cmd = new SqlCommand("dbo.addXXX_Test", con.Connection);
cmd.CommandType = CommandType.StoredProcedure; 
cmd.Parameters.Add(new SqlParameter("@p_Name", SqlDbType.VarChar));
cmd.Parameters["@p_Name"].Size = 40;
cmd.Parameters["@p_Name"].Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(new SqlParameter("@p_DecimalCheck", SqlDbType.Decimal));
cmd.Parameters["@p_DecimalCheck"].Precision = 19;
cmd.Parameters["@p_DecimalCheck"].Scale = 5;
cmd.Parameters["@p_DecimalCheck"].Value = 5.123;

con.ConnectionString is just a connection string to the database.

The table structure in sql server is:
create table dbo.XXX_Test
   Name VARCHAR(40),
   DecimalCheck DECIMAL(19,5) null
) ON Test_Data

When I execute above code and do select * from XXX_Test, it shows .05123 for
DecimalCheck instead of 5.123.

Hope this helps.


Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
You are the assignee for the bug.

More information about the mono-bugs mailing list