Add Fields To a Table with X++ , Dynamically

Add Fields To a Table with X++ , Dynamically

There is 2 ways to create a fields for Table.

1.New Table with New Fields

2. Add New fields To Existing Table

1.Create a New Table with New Fields

static void newTableCreate112(Args _args)
{
TreeNode treeNode;
AOTTableFieldList fieldList;
#AOT
;
treeNode = TreeNode::findNode(#TablesPath);

treeNode.AOTadd("Test_ABC");

SqlDataDictionary::synchronize();

//treeNode.AOTfindChild('naresh3');

fieldList = treeNode.AOTfindChild('Test_ABC').AOTfindChild('fields');
fieldList.addString('Name');
fieldList.addInteger('Id');
fieldList.addString('Address');
fieldList.addReal('Salary');

print "Table Created";
pause;
}
2.Add New fields To Existing Table

static void newFieldCreate(Args _args)
{
TreeNode treeNode;
AOTTableFieldList fieldList;
#AOT
;
treeNode = TreeNode::findNode(@'\\Data Dictionary\Tables\Test_ABC\');
fieldList = treeNode.AOTfindChild('fields');
fieldList.addInteger('Mobile');
SqlDataDictionary::synchronize();
print "Field Created";
pause;
}