Tuesday, March 24, 2015

Change table field property

static void TableFieldUpdate(Args _args)
{
    TreeNode            vendFldsRoot = treeNode::findNode(@"\Data Dictionary\Tables\ScobTopVendors\Fields");

    TreeNodeIterator    vendFldsIterator;

    TreeNode            vendFlds;

    NoYes               visibleProp;
    Table1              table1;
    Name                name;
    str property;
    ;



    vendFldsIterator = vendFldsRoot.AOTiterator();

    vendFlds = vendFldsIterator.next();



    while(vendFlds)

   {

        name = vendFlds.treeNodeName();
       select * from table1 where table1.Companyname == name;
       Property       = vendFlds.AOTgetProperties();
       Property       = SetProperty(Property, "name",table1.label);
     
           vendFlds.AOTsetProperties(Property);
           vendFlds.AOTcompile();
           vendFlds.AOTsave();
     

        vendFlds    =   vendFldsIterator.next();

    }

}

No comments:

How to identify the user that was used to change an object from AOT in AX2012

Get the object name for which we need to track these (user and date&time) information's. Login to SQL Server Management Studio an...