Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Thursday, June 27, 2013

inserting into table by job in AX X++

static void DataDic_InsertRecord(Args _args)
{
MyTable myTable;
;
ttsbegin;
myTable.initValue();
myTable.accountNum  = "100";
myTable.custName  = "Alt. customer id 100";
myTable.custCurrencyCode  = "USD";
if (myTable.validateWrite())
myTable.insert();
ttscommit;
}

X++ job using container


static void Intro_For(Args _args)
{
Container names = ["Lay", "Kai", "Zbigniew", "Rolf", "Memed"];
Counter counter;
;
for (counter=1; counter <= conlen(names); counter++)
{
info(strFmt("%1: Name: %2", counter, conpeek(names, counter)));
}
}

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,