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

I do not envy you.  I'm still in shock over the VAL thing....<VBG>

Drew

-----Original Message-----
From: Michael Maddison [mailto:michael.maddison at ddisolutions.com.au]
Sent: Wednesday, February 19, 2003 12:28 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Puzzling error msg? <Invalid precision for
decimal data type.>


Drew,

It is really strange because I remove all the calced fields and just
leave a string field in the select statement,
try to create a recordset and it fails with the same error!!!  This
leaves me thinking that it has to be a problem in
the joins somewhere (or Access hates me).  I've checked the top level
but I guess I'll have to burrow into the base
queries, maybe run them individually and see what I find.

Michael M


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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com