[AccessD] CDec behaviour in SQL and VBA

[Jim Dettman]

 Yes and no.  When your using SQL, it runs through an expression service
while VBA does not.   The procedure calls in the expression service can be
different than what's in VBA and there have been minor differences over the
years in that area (SQL vs VBA).

 I had a long drawn out thread with Bret Spalding on EE at one time. I'll
see if I can't dig it out.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Friday, July 10, 2015 04:49 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] CDec behaviour in SQL and VBA

Hi all

Weird. I know Decimal is claimed to be buggy, but this is beyond "buggy", I
think:

http://stackoverflow.com/questions/31327402/cdec-in-access-sql-is-not-behavi
ng-the-same-as-when-used-from-access-vba

I can reproduce the described behaviour in Access 2013.

/gustav
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com