AX 2012 Select Statement for a field name using reserved word

(0) Share

Report

Posted on by mwpage

200

I would like to do a select statement with a field list, but one of the fields in the list uses one of the AX reserved words, can anyone help with this. If it isn't possible then I think that's a big miss in the X++ select statement syntax.

The Table I'm trying to pull from is BIDateDimensionValue, and the field is Date. i.e. I want to do this:

Select Date from biDateDimensionValue;

or this:

(Select BIDateDimension).Date;

but it throws a compile error, I've tried several different things, but to no avail. Any ideas (besides Select *, or simply not using reservered words in field names)

Thanks!

-matt

*This post is locked for comments

I have the same question (0)