![]() |
#2 |
Участник
|
axStart: Unretrieved values on the companyinfo Table in AX 2012R2.
Источник: http://www.axstart.com/unretrieved-v...e-in-ax-2012r2
============== In AX 2012 R2, table inheritance tables are all stored in the same table. ![]() So the Company Info table is on SQL level stored in the table DirPartyTable. They did this for performance reasons. But what happens when you insert a new Colom on that table. We get unretrieved values like below screen. ![]() Normal fields in AX tables are not allowed to be NULL, so there is always an empty string or a zero value in it. (Note DirParTable fields are of not null) ![]() The fields are NULL so the will not use disc storage. So how do you solve this. In the next example I added an field on DirOrganizationBase, So all derived table records needs to be updated UPDATE DIRPARTYTABLE SET YOURFIELD = ” WHERE YOURFIELD IS NULL and ( INSTANCERELATIONTYPE = 6886 or — DirOrganizationBase INSTANCERELATIONTYPE = 2975 or — DirPerson INSTANCERELATIONTYPE = 41 or — CompanyInfo INSTANCERELATIONTYPE = 2978 or — DirOrganization INSTANCERELATIONTYPE = 2376 or — OMInternalOrganization INSTANCERELATIONTYPE = 2377 or — OMOperatingUnit INSTANCERELATIONTYPE = 5329 – OMTeam ) In case of a number or enum it is SET YOURFIELD = 0 Источник: http://www.axstart.com/unretrieved-v...e-in-ax-2012r2
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|