Transaction Statements in ax 2012

Delete_from : delete multiple records at a time

EX:-

Custtable _custtable;

;

delete_from custtable where custtable.Accountnum == “4018”;

Update_recordset : Update multiple records at a time.

Ex:-

Salestable   _salestable;

;

Update_recordset _salestable setting salesName =”New enterprises” where _salestable.CustAccount == “2001”

       

Insert_recordset: insert multiple records at a time.

Ex:- MYtable1  mytable1;

     MYtable2 mytable2;

     ;

     Ttsbegin;

     Insert_recordset mytable2 (myField1, myField2) select myField1, myField2 from mytable1;

     Ttscommit;