Number of records

This job displays the number of records in each table: static void getTableRecordCount(Args _args) { #AOT Name name; NumberOf recordCount; TreeNode treeNode; SysDictTable sysDictTable; ; treeNode = TreeNode::findNode(#TablesPath); treeNode = treeNode.AOTfirstChild(); while (treeNode) { name = treeNode.AOTname(); sysDictTable = SysDictTable::newTableId(treeNode.applObjectId()); recordCount = sysDictTable.recordCount(false); if (recordCount) info (strfmt("@SYS26868", name, recordCount)); treeNode = treeNode.AOTnextSibling(); } }

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.