D365F&O - X++ - Insert records in database using recordInsertList

public void insertCustRecords(CustStatementDirTmp _custStatementDirTmp, Query _userQueryPacked)

{

        CustTable               cust;

        QueryBuildDataSource    dataSource;

        QueryRun                partyRun;

        Query                   Query = new Query(_userQueryPacked);

        RecordInsertList        recordInsertList;

   

        partyQuery.allowCrossCompany(false);

   

        dataSource = partyQuery.dataSourceTable(tableNum(CustTable));

   

        partyRun = new QueryRun(partyQuery);

   

        recordInsertList = new RecordInsertList(_custStatementDirTmp.TableId, false, false, false, false, true, _custStatementDirTmp);

   

        // Add customer parties in current company

        while (partyRun.next())

        {

            cust = partyRun.get(tableNum(CustTable));

   

            _custStatementDirTmp.clear();

            _custStatementDirTmp.Party = cust.Party;

            _custStatementDirTmp.CustCompany = cust.DataAreaId;

            _custStatementDirTmp.CustRecId = cust.RecId;

            recordInsertList.add(_custStatementDirTmp);

        }

        recordInsertList.insertDatabase();

}