Friday 8 February 2013

How to find out number of records in each table using code?

static void myJob(Args _args)
{

#AOT
#Properties
TreeNodeIterator iterator;
TreeNode treeNode;

iterator = Treenode::findNode(#TablesPath).AOTiterator();
//make the tree node point to the first table

treenode = iterator.next();

while (treeNode)

{

if (treeNode.AOTgetProperty(#PropertyTableGroup) == 'Main' && treeNode.AOTgetProperty(#PropertySaveDataPerCompany) == 'Yes')

{

info(strFmt("Table Name : %1 Legal Entity: %2 Total Records:%3", treenode.AOTname(), curext(),SysDictTable::casRecordCount(TreeNode.AOTname(),true)));

}

treeNode = iterator.next();

}

}