Wednesday, November 18, 2020

Common table in Ax 2012

Common : The system table Common is the base for all tables. The table contains no data, and the table can be compared with a temporary application table. Common is used like the base type anytype. You can set any table equal to the table Common. This is useful if you need to transfer a table as a parameter and not knowing the exact table before execution time

static void DataDic_Common(Args _args)

{

Common common;

CustTable custTable;

;

common = custTable;

if (common.tableId == tablenum(custTable))

{

while select common

{

info(common.(fieldnum(custTable, name)));

}

}

}

The example above is initializing Common with CustTable. A check is made to assure that Common is now equal to CustTable. All records from CustTable are looped, and the customer name is printed in the InfoLog. Notice, the system function fieldnum() is used to get the field name printed. If you do not know the fieldname at runtime, you can enter the field id in parentheses instead.