[AccessD] Puzzling error msg? <Invalid precision for decimal data type.>

So you don't have the problem with Access right?  That kind of sucks,
because with Access, you could put a user defined function into the query,
and have it let you 'walk' through the records...so you could trace where it
has a problem.

Drew

-----Original Message-----
From: Michael Maddison [mailto:michael.maddison at ddisolutions.com.au]
Sent: Tuesday, February 18, 2003 10:47 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Puzzling error msg? <Invalid precision for
decimal data type.>


John,

You would think so from the msg wouldn't you?  I've checked and double
checked.  Apart from the explicit casts
to cDbl I've also check the actual values returned by the query to the
target table and there is nothing out of the ordinary.
Ints look like ints and the doubles start at 0 and go to only a couple
of hundred (428.9).  

I've never seen this error before!

cheers

Michael M



	Just off the top of my head... is that a long int trying to
shoehorn into a decimal?  If so, then the significant digits in front of
(left of) the decimal place may have too many digits.

	Just a wag.

	John W. Colby
	Colby Consulting
	www.ColbyConsulting.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com