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

[bugzilla_noreply at novell.com]

http://bugzilla.novell.com/show_bug.cgi?id=595918

http://bugzilla.novell.com/show_bug.cgi?id=595918#c0


           Summary: Decimal parameter stored incorrectly from sql stored
                    procedure
    Classification: Mono
           Product: Mono: Runtime
           Version: 2.4.x
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Critical
          Priority: P5 - None
         Component: debug
        AssignedTo: martin at novell.com
        ReportedBy: kjeevan_kumar at yahoo.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---
           Blocker: ---


User-Agent:       Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR
1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)

When I call ExecuteNonQuery after assigning a decimal parater (which is
decimal(9,5)) according to the stored procedure script) with value 5.123, it is
getting stored as 0.05123, if I pass 5.12, it is stored as 0.00512. But if I
pass as "5.12" (a string), it is saved as 5.12000. 

Can anyone please help me with this.

Thanks

Reproducible: Always

Steps to Reproduce:
1. Use SqlCommandBuilder.DeriveParameters to derive parameters of stored
procedure
2. Pass a value of 5.12 to a decimal parameter
3.

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