web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :

Get Field, Label, Type and Name using X++

Sheikh Sohail Profile Picture Sheikh Sohail 6,125





Following are they way to get Table Label
static void Job21(Args _args)
{
    info(TablePName(CustTable));
}




Following are they way to get Field Label of the table
static void Job21(Args _args)
{

    info(fieldPName(CustTable,AccountNum));
}



Following is the way to find Label , Name and Data type of all fields of any table.
static void Job21(Args _args)
{

    DictTable       dt=new SysDictTable(tableNum(CustTable));
    FieldId       _fieldId=  dt.fieldNext(0);
    DictField     _dictField;
    
while(_fieldId)
    {
      _dictField  =dt.fieldObject(_fieldId);
 info(strFmt("Field Name %1 , Field Lable %2 and Field Type %3", _dictField.name(),_dictField.label(),_dictField.type()));
     _fieldId=  dt.fieldNext(_fieldId);
    }
}



This was originally posted here.

Comments

*This post is locked for comments