HomeActive Query BuilderSelect on MS Access DB with non-standard column names

Select on MS Access DB with non-standard column names


SITUATION

A MS Access DB where some of the column names include paranthesis.

ERROR MESSAGE

Cannot execute SQL: ....
Undefined function 'T.RESULT' in expression.

EXAMPLE

A table ACTSTATISTIC with columns:
RECID, ITEMID, RESULT(SCRAPITEMS), RESULT(SPAREITEMS)

A SQL statement:
select T.ITEMID T.RESULT(SCRAPITEMS), RESULT(SPAREITEMS) FROM ACTSTATISTIC AS T

QUESTION

How can AQB handle such columns? Is there a solution / workaround for this particular problem? We cannot change the column names as this is a COTS product. AQB was bundled to allow generating additonal ad-hoc reports from the MS Access DB.

Many thanks in advance, roland
roland
August 19 2009, 07:40 AM
Dear Roland,

The query that you mentioned is not valid in terms of MS Access database. You must quote the non-standard field names with square brackets according to the syntax rules of MS Access. This is not the limitation of Active Query Builder.
Sergey Smagin | email
6 days, 18 hours since original post
This topic is closed