Hi One thing that might be different is that the field is of type NUMERIC(9,2) although this comes from a domain create domain FLOAT_2 as numeric(9,2);
I have just inserted into another table, where one column was of type NUMERIC(9,4) and the other was of type NUMERIC(9,4) but was of domain FLOAT_4 which is of type numeric(9,4). The one which wasn't from a domain went in fine, but the one in a domain went in as 1/100 of the value I sent to the database. Is this a bug? Roger -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Carlos Guzmán Álvarez Sent: 21 February 2006 14:12 To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] numeric values Hello: > Am I doing something wrong or is this a bug? It looks as working for me, here is my test case: FbConnection c = new FbConnection(csb.ToString()); c.Open(); decimal d = 10.2M; FbCommand cmd = new FbCommand("insert into new_table (new_field) values (@value)", c); cmd.Parameters.Add("@value", FbDbType.Numeric).Value = d; cmd.ExecuteNonQuery(); c.Close(); And the DDL of the table i'm using: CREATE TABLE NEW_TABLE ( NEW_FIELD NUMERIC(9,2) ); -- Best regards Carlos Guzmán Álvarez Vigo-Spain ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
