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++ - Best Practice Warning BP Rule: [BPErrorUnknownLabel]: Path:

To resolve the following error:  Path: [dynamics://Table/SalesTable/Field2]:Unknown label ‘@ZILabel:NewLabel’. Legacy labels (such as the label id @SYS12345) are case insensitive and modern labels (such as ‘MyLabelId’ in @MyLabelFile:MyLabelId) are case sensitive. Use upper casing when referring to legacy labels and exact casing for modern labels.  use  literalStr()  before the custom label. info(literalStr(" @ZILabel:NewLabel " ) ) ;
Read more

D365F&O - X++ - How to Enable/Disable button on form based on a condition in D365F&O using Event handlers.

Image
1- Create a new class SalesOrderFormEventHandlers . 2- Go to SalesTable form. 3- Expand SalesTable datasource. 4- Expand Events , right click on OnActivated and click on Copy event handler method. 5- Paste the code in your  SalesOrderFormEventHandlers class. 6- Save and build your project. class SalesOrderFormEventHandlers {     /// <summary>     /// Enable or disable Refund button     /// </summary>     /// <param name="sender"></param>     /// <param name="e"></param>             [FormEventHandler(formStr(SalesTable), FormEventType :: Activated)]     public static void SalesTable_OnActivated(xFormRun sender, FormEventArgs e)     {           // Button control name in your form design         #define.BUTTONNAME( 'JWRefundButton' )         FormDataSource form_ds = sender.dat...
Read more

D365FO - X++ - Generate CAR (Customized Analysis Report) report of custom model

Image
1- Open command prompt by clicking on "Run as Administrator". 2- Select the drive where your model and package exist in command prompt. My custom model is in K: folder. W rite the following command.   3- Copy the following command and run. K:\AosService\PackagesLocalDirectory\bin\xppbp.exe -metadata=K:\AosService\PackagesLocalDirectory -all -model=yourModel -xmlLog=K:\BPCheckLogcd.xml -module=yourModel -car=K:\CARReport 4- After successful completion, the CAR report will be saved to the given path
Read more