For what it's worth, I am making excessive use of parameters with type Decimal, and I am experiencing _no_ problem at all.
I am in the process of eliminating the last non-Firebird portions of databases our softare is based upon and only then will I be able to migrate from 1.5.x to the current 2.x branch. So, I am still using the 2.01 provider and FB 1.5 (all Dialect 3), if that's of any importance for determining why Decimal parameters are working fine for me. I am, though, declaring the parameters another way than you do. Specifically I do not declare precision and scale on the client side. All my Decimals do have at least a precision of 12 while yours obviously only has 8. According to Helen's Book, Decimals with precision < 10 are stored differently. I am not in the position to guess if that can somehow be connected to your problem. But it's worth trying, so you could leave out the declaration of the precision and scale and also try with a target field of higher precision and scale. ciao, André -- ~~~Ihre Nachricht~~~ KG> Hi Daniel, KG> I'm not at my workstation today, so I can't cut and paste anything. I will KG> try tomorrow. KG> However, I can mention that I am using the provider in probably two dozen KG> projects, and in each project I have at least 50 parameterized inserts. In KG> no case am I able to use the decimal type. KG> If I insert to a decimal field using a FbDbType.Integer, the insert works, KG> though the decimal portion is truncated, KG> If I insert to the decimal field using an FbDbType.Float, the insert works. KG> I'll try to send more code for context tomorrow. KG> Thanks, KG> Kyle KG> ----- Original Message ----- KG> From: "Daniel Rail" <[email protected]> KG> Sent: Mon, January 25, 2010 14:41 KG> Subject:Re: [Firebird-net-provider] FbDbType.Decimal param fails KG> Hi, KG> At January-25-10, 5:19 PM, Richard Green wrote: >> Using this, the insert fails with this message: >> "The string was not recognized as a valid DateTime. There is a unknown >> word starting at index 0" KG> Can you show us all of the insert statement and then the code that KG> creates the FbParameter[] and assigning of the values? ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
