record insert list in D365FO

 record insert list in D365FO. By using this system insert the data into SQL at one time.

• For temp Table : Click here

• This post is for Regular table

[Table method]

Public static Void getTable(CustTable  _custTable)

{
    MYTempTable         myTable;
    SalesTable          salesTable;
    RecordInsertList    recordInsertList = new RecordInsertList(tableNum(MYTable));

    while select salesTable
       where salesTable.CustAccount == _custTable.CustAccount 	
    {
            myTable.clear();
            myTable.CustAccount = salesTable.custAccount; 
            myTable.SalesId     = salesTable.SalesId;

            recordInsertList.add(myTable);
     }
       recordInsertList.insertDatabase();
}

Keep Daxing!!