Question Status

Suggested Answer
PKCrockett asked a question on 13 Nov 2013 8:48 AM

In a T-SQL query if you encounter this problem, you can specify a column alias using square brackets such as [DATE].  Is there a way to do this in an X++ query? Thanks.

Reply
Suggested Answer
Tommy Skaue responded on 13 Nov 2013 10:57 AM

Design around the "problem" by giving the column a better name. "Date" is an uninventive and unintuitive name for a date column, and while I can name numerous reasons not to call a column date, I can't think of one single reason for calling it date.

:-)

Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

Reply
Suggested Answer
Tommy Skaue responded on 13 Nov 2013 10:57 AM

Design around the "problem" by giving the column a better name. "Date" is an uninventive and unintuitive name for a date column, and while I can name numerous reasons not to call a column date, I can't think of one single reason for calling it date.

:-)

Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

Reply
Martin Dráb responded on 13 Nov 2013 11:22 AM

What problem are you trying to address? Because you can refer to a field called Date in X++ (although I agree with Tommy that you shouldn't use such a name - it's even a keyword in X++).

Martin "Goshoom" Dráb | Freelancer | Goshoom.NET Dev Blog

Reply