D365F&O - X++ - delete_from in X++ AX2012 and D365 F&O

 delete_from is used to Delete all records from a table at once based on some condition.

//declare your table varibale
CustTable  custTable;

 

ttsbegin;

// Delete all records without any condition
delete_from custTable;


//delete records based on some condition
delete_from custTable
 where custTable.AccountNum == "Cust12345677";

Comments

Post a Comment

Popular posts from this blog

D365F&O - X++ - Set contract parameter value in controller class of SysOperationServiceBase framework

/// <summary> /// A class entry point /// </summary> /// <param name = "_args">An instance of <c>Args</c> which /// contains calling arguments</param> public static void main(Args _args) {     str caption;     ItemExportController   controller;     controller = ItemExportController::construct(); // get data contract object     ItemExportContract contract = controller.getDataContractObject();      // set data parameter value     contract.parmitemExportSystem(_args.parmEnum());             controller.parmArgs(_args);     controller.startOperation(); }
Read more

D365F&O - X++ - Create Batch job using SysOperationServiceBase in X++

 1- Create Contract class if you want to create any parameters. [DataContractAttribute] class SysOperationsBatchContract {     TransDate asofDate;     [DataMember,     SysOperationLabel(literalStr( "As of Date" )),     SysOperationHelpText(literalStr( "Show records As of Date." )),     SysOperationDisplayOrder( '1' )]     public TrandDate parmAsOfDate( TrandDate _asofDate = asofDate)     {         asofDate = _asofDate;         return asofDate;     } } 2- Create new Controller class. public class SalesOrderRefundBatchController extends SysOperationServiceController {     /// <summary>     /// Default class contsructor     /// </summary>     protected void new()     {         super (classStr(SalesOrderRefundBatchService),                ...
Read more

D365F&O - X++ - Create and post Customer payment Journal using X++ code.

 1- Create a new class  CreatePaymentJournal. class CreatePaymentJournal {     public void createPaymentJournal()     {         System . Exception                    exception;         LedgerJournalTrans                  journalTrans;         Ledgerjournalname                   ledgerjournalname;         NumberSeq                           numberSeq;         LedgerJournalTable                  journalTable;         MCROrderParameters                  Parameters = MCROrderParameters :: find();         DimensionAttributeVal...
Read more