List of mandatory fields on a table

  • February 22, 2010
  • 0 Comments

When you want a list of all the mandatory field on table X, yould check all the properties on the table fields, or you could be lazy and write a small job that does the trick for you. Just replace TableId with your tablenum.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
static void CheckMandatoryFieldsOnTable(Args _args)
{
DictTable dictTable;
DictField dictField;
int i;
TableId tableId = tablenum(custtable);
;
dictTable = new DictTable(tableId);
for (i=1 ; i<=dictTable.fieldCnt() ; i++)
{
dictField = new DictField(tableId, dictTable.fieldCnt2Id(i));
if (dictField.mandatory())
{
info(dictField.name());
}
}
}