Thursday, December 15, 2016

Update and Update_RecordSet Code sample in Ax 2012

This is Update and Update_RecordSet Code sample. Result of both will be same .

 TestTable TestTable;  
   
//Update_Recordset
update_recordset TestTable setting Name ="New Enterprises" where TestTable.Accountnum =="uS-027";  
   
//Update
ttsBegin;  
   while select forupdate TestTable where TestTable.Accountnum =="uS-027"  
   {  
     TestTable.Name ="New Enterprises";  
     TestTable.update();  
   }  
   ttsCommit;  
   info("OK");