Hi Daniel, I'm not at my workstation today, so I can't cut and paste anything. I will try tomorrow.
However, I can mention that I am using the provider in probably two dozen projects, and in each project I have at least 50 parameterized inserts. In no case am I able to use the decimal type. If I insert to a decimal field using a FbDbType.Integer, the insert works, though the decimal portion is truncated, If I insert to the decimal field using an FbDbType.Float, the insert works. I'll try to send more code for context tomorrow. Thanks, Kyle ----- Original Message ----- From: "Daniel Rail" <[email protected]> Sent: Mon, January 25, 2010 14:41 Subject:Re: [Firebird-net-provider] FbDbType.Decimal param fails Hi, 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" Can you show us all of the insert statement and then the code that creates the FbParameter[] and assigning of the values? -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) ------------------------------------------------------------------------------ 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 ----- End of original message ----- ------------------------------------------------------------------------------ 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
