Dynamics AX 2012


How to get the Name and Value from an undefined table and field


while select * from SqlDictionary

where SqlDictionary.tabId == tableName2id(Tablename)

&& SqlDictionary.fieldId != 0





{


fieldname = SqlDictionary.sqlName;


dict = new SysDictField(SqlDictionary.tabId,SQLDictionary.fieldId);

label = strReplace(strReplace(SysLabel::labelId2String(Dict.labelLabel(),LanguageID),"-","_")," ","_");

if(label =="")






{


file.write(strFmt("%1%2.%3,",Praefix,Tablename,FieldName));






}


else





{


file.write(strFmt("%1%2.%3 as %4,",Praefix,Tablename,FieldName,Label));






}