Add Fields To a Table

Hai to all ,

i already posted this Question earlier,but i didn,t get the proper solution.

Now i got the solution with the help of my Friend.so i want to share this code .i hope this may helpful for others.

There is 2 ways to create a fields for Table.

1.New Table with New Fields

  1. 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(“ABC”);

SqlDataDictionary::synchronize();

treeNode.AOTfindChild(‘naresh3’);

fieldList = treeNode.AOTfindChild(‘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\ABC’);
fieldList = treeNode.AOTfindChild(‘fields’);
fieldList.addInteger(‘Mobile’);
SqlDataDictionary::synchronize();
print “Field Created”;
pause;
}

Thanks & Regards

I cannot think of any solution where this would have to be required.

I mean it is not very good to allow some code unlimitedly create new physical fields on tables… How are you going to use those fields later? You would still have to drag them to forms (at least field groups)… reports…

Hey,

what do you searhing in this forum,you giving replies to all the posts as Normal 0 false false false EN-GB X-NONE X-NONE

If u Know the Solution Give reply (or) any suggestion.But Not Do like this.I need to know for Write the Code for all oblects In AOT throw X++.

this forum is very helping to me.I like this .Y u giving replies to all people like this.

Thanks & Regards

Hello Naresh

This Code is Use able For 2 Table Fields Am I Add Two Tables Fields In Other’s Table Field Group

thanks & regards

ali