Thursday, August 16, 2012

List of mandatory fields on a table

Hi All,
   The Following Code will let you know the List of Mandatory Fields in a table :-


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());
        }
    }
}

Enjoy DAX !!!

No comments:

Post a Comment

Use Chain Of Command with Examples

 Dear Friends Here is an example of using Chain of Command for form datasource methods. [ExtensionOf(formDataSourceStr(<<Form Name>...