Truncate table using x++

-
Below job is to truncate VendGroup table using x++.

   SqlDataDictionary sqlDataDictionary;
    ;
    sqlDataDictionary = new SqlDataDictionary();

    new SqlDataDictionaryPermission(methodstr(SqlDataDictionary, tableTruncate)).assert();
    sqlDataDictionary.tableTruncate(tablenum(VendGroup),false);

Comments

Post a Comment

Popular posts from this blog

Dynamics 365 Finance & Operations Release pipelines import.

-
Image
Download release pipeline Json/Yml file for your version from github  samples which is for Microsoft hosted agents . Go to Azure Devops and go to Pipeplines page. Click on right side pipe symbol and click "Import a Pipepline" shown below. Once imported, most of the values will be blank and need to be fixed. If you have build VM, then upload attached Json file and modify.
Read more

Attaching a user selected document to a purchase order using x++ job (Runnable class) in Dynamics 365 for Finance and Operations

-
While working in document management in Microsoft Dynamics 365 for Finance and Operations, For testing purposes I wanted to attach documents to some posted tables and written a simple program to get files from user and attach to the record. Modified same to show how it work with PurchTable. class   Jobs {      public   static   void  main( Args  _args)     {         PurchTable               purchaseTable;        System.Net. WebClient     webClient;        System.IO. MemoryStream   stream; FileUploadTemporaryStorageResult  fileUploadResult =  File ::GetFileFromUser ( classstr ( ImageFileUploadTemporaryStorageStrategy ));                  if  (fil...
Read more

Claude AI Models Comparison (Updated: July 2026): Haiku 4.5 vs Sonnet 5 vs Opus 4.8 vs Fable 5

-
 Artificial Intelligence (AI) models continue to evolve rapidly, with each new generation offering improvements in speed, reasoning, and specialized capabilities. However, using the most powerful model for every task isn't always the best choice. Larger models deliver stronger performance but also consume more AI credits and may take longer to respond. This guide explains when to use Haiku 4.5 , Sonnet 5 , Opus 4.8 , and Fable 5 , helping you choose the right model for the right job. Why Choosing the Right Model Matters Each Claude model is designed for a different level of complexity. As you move from Haiku to Fable , you gain stronger reasoning, deeper analysis, and more advanced capabilities—but you also use significantly more AI credits. For most day-to-day work, Sonnet 5 provides the best balance between performance, speed, and cost. Haiku 4.5 – Best for Light and Fast Tasks ⚡ Best for Quick rewrites Short summaries Simple questions Formatting cleanup Gra...
Read more