Monday, 23 December 2013

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.

No comments:

Post a Comment