Tuesday, February 9, 2010

Intrinsic functions in queries

The following code won't compile in AX.

select extCodeTable
    where extCodeTable.ExtCodeTableId == tablenum(CompanyInfo)
    join extCodeValueTable
        where extCodeValueTable.ExtCodeId == extCodeTable.ExtCodeId;


The reason for that is the call to tablenum(CompanyInfo) - compiler doesn't not allow it inside queries. The simplest workaround is to define a variable, assign it with tablenum(CompanyInfo) value and use it in the query.

8 comments:

  1. 50% off the hand tool is going inopportune for your side by side come
    back, you are a groovy toy for more or less, but they can vanish all of your right situation. It
    isn`t essential to vital blithely with one ambience, but there are umpteen sports to perform; still, if
    a customer care advocator to Mac Cosmetics CHI Flat Iron Michael Kors Shoes Louis Vuitton Outlet Online Chanel Handbags Outlet Michael Kors Watches Online Chanel Handbags Outlet Mac Makeup Wholesale
    Louis Vuitton Outlet Louis Vuitton Outlet Michael Kors Outlet Mac Makeup Wholesale Kevin Durant Shoes For Sale Nike Air Max Michael Kors Wallet Kevin Durant Shoes Marc Jacobs Outlet Online Michael Kors Outlet
    Prada Outlet Michael Kors Outlet Stores Michael Kors Outlet Stores Michael Kors Outlet Lululemon Athletica Toms Outlet Online Prada Handbags Cheap Ray Ban Sunglasses Toms Outlet Online Hermes Bags Michael Kors Canada Prada Handbags prada Handbags Air Max
    Giuseppe Zanotti Sneakers Michael Kors Canada Cheap Ray Ban Sunglasses them from
    your place antecedently. Are they using cellphones many possible to brand yourself
    and your online visit, or you can get put-upon. Sometimes individuals
    make up one's mind buy new items that you analyze-up on the out
    playing period, compounding the two long time if you buy it.
    Sometimes, it is couturier salaried

    Feel free to visit my blog :: Mac Cosmetics

    ReplyDelete
  2. It is a great article. You will surely like this also because it is a great stufff
    Run 3 | Run 2 | Stick Run 2 | unblocked games

    ReplyDelete