Dynamics Community Forum Thread Details

Delete records from Datasource

Hello everyone, I am trying to delete data from SalesParmTable on SalesEditLines. The problem is that when I do so, I get the confirm deletion notification and the user needs to press Yes to confirm.

I am not sure if there is a way to bypass that.

here is my code.

void chooseTable(boolean _checkForReArrange)    {               next chooseTable(_checkForReArrange);                        SalesParmTable      salesParmTableFromDataSource = salesParmTable_ds.cursor() ;        SalesParmTable      salesParmTableFromTable;        CustParameters      custParameters = CustParameters::find();        if (custParameters.xxPendingSalesInvoice == NoYes::Yes && salesFormLetter.parmCreateFromHistory() == false )        {                        while (salesParmTableFromDataSource)            {                                //salesParmTableFromDataSource =salesParmTable_ds.cursor();                while select  salesParmTableFromTable                    where salesParmTableFromTable.SalesId == salesParmTableFromDataSource.SalesId                                 {                    if (salesParmTableFromTable.xxProFormaInvoice && salesParmTableFromTable.ParmJobStatus == ParmJobStatus::Waiting)                    {                                                ttsbegin;                                                salesParmTable_ds.delete();                                                                        ttscommit;                        warning(strFmt(/a pending invoice already exist for %1 /,salesParmTableFromTable.SalesId));                                                break;                    }                                }                               salesParmTableFromDataSource = salesParmTable_ds.getNext() ;                salesParmTable_ds.next();            }        }    }

If you want to silently delete records from code, use delete() on a table buffer instead of the one one data source (salesParmTable_ds.delete()). By the way, it's strange that fetch records in the while select loop, but then you delete a different record. If you want to delete the records fetched by the while select, use salesParmTableFromTable.delete(), because salesParmTableFromTable is what you get from the query. If you want to delete the current record of salesParmTable_ds, you can simply use salesParmTable.delete(). By the way, it's usually a good idea to check whether a record can be deleted (validateDelete()) before actually doing it.

If you want to use your current approach, user options allow configuring for which types of tables is this confirmation displayed.

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL