Re: Decimal Precision error. GRRRR

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sorry,..
"The decimal field's precision is too small to accept tghe numeric you attempted to add."
The problem field is in a MYSQL DB, decimal type 8.4. Wrapping it in a Cdbl() makes no difference.

Note, it does not happen whenever I use this field, not even when I pull data using the exact same criteria. therefore getting the exact same records. I have a report that pulls similar data, including this same field, using the same criteria from thesame form, that works fine.

John Vinson wrote:
On Tue, 28 Nov 2006 15:34:19 -0800, Phil Smith <phil@xxxxxxxxxxx>
wrote:


Is there any way to avoid this damn error?


What's the error? You haven't said.


Trying to convert using CDbl() does not work.


Trying to convert WHAT to CDbl()?


As best as I can tell, all of the data fits 8.4, which is the way the field is configured, which means it is a bogus error.
This is a select query from a an ODBC connected table.


In what database?

Please give us some help, Phil. We can't see your screen.

John W. Vinson[MVP]
.