Hello:
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);
This looks as working fine for ( working against Firebird 2.0 ) :
FbConnection c = new FbConnection(csb.ToString());
c.Open();
decimal d = 10.2M;
FbCommand cmd = new FbCommand("insert into new_table (numeric_field)
values (@value)", c);
cmd.Parameters.Add("@value", FbDbType.Numeric).Value = d;
cmd.ExecuteNonQuery();
c.Close();
The DDL:
CREATE DOMAIN NUMERIC_DOMAIN AS
NUMERIC(9,2);
CREATE TABLE NEW_TABLE (
NUMERIC_FIELD NUMERIC_DOMAIN
);
Let me know if the test is correct.
--
Best regards
Carlos Guzmán Álvarez
Vigo-España
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
