2011 m. balandžio 4 d., pirmadienis

Selecting Cached Tables

Dynamics AX ignores specific fields selection if all the folowing contitions are fulfiled:
  • Table has CacheLookup property set to NotInTTS, Found or FoundAndEmpty
  • Table has a primary key
  • Selecting tables' primary key with (==)

Example:
select ProjId, ProjGroupId, Name from projTable where projTable.ProjId == "PROJ-00123";

if projTable meets above mentioned conditions the result will be entire record, not only ProjId, ProjGroupId, Name fields.

Komentarų nėra:

Rašyti komentarą