[AccessD] Bug in access

Hi John:

That is truly ugly. Have you officially reported that bug?

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, November 10, 2009 9:29 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Bug in access

I am working on a project where I use a table to fynamically build a query.
The table has field 
names in it, and I can just append those field names into a select string
and voila, it works. 
place the field names you want in the table and a select statement is
created of those fields.  This 
system is shuffling fields around from scanned documents (CSV files) to get
them into a standard order.

OK, so I can also use entire functions such as format(Field1,"000.00") and
that works.  cSng(Field1) 
works.  cDbl(Field1) does NOT WORK.  It complains that the function cDbl
needs two parameters, but 
if I supply anything in the second parameter, then cDbl works (no longer
complains) but returns a zero.

To test this bug, create an aliased field in a query something like

Select cDbl("123.45") as SomeField, etc etc

The QBE will immediately complain about cDbl needing another parameter.  Try
the same thing with 
cSgl("123.45") and it works just fine.

The bugs we have to work around.  Sigh.

But hey, we have a shiny new tool bar.  ;)

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