Index vs Index hint

  • October 1, 2010
  • 4 Comments

This is a discussion I had with several colleagues. What is the difference between index and index hint and what do we use in our code?

SQL Server Activity Monitor

  • September 29, 2010
  • 0 Comments

I know there are much more fancy tools you can buy on the market than the standaard build-in Activity Monitor from SQL Server, but is a usefull tool that can help you monitor your Server. You can find it when you right-click on the server instance and then click on Activity Monitor. The 2 grids … Continue Reading

Where are breakpoints stored in Ax 2009

  • September 27, 2010
  • 0 Comments

In Ax 2009 breakpoints are stored in 2 tables, the SysBreakpointList and the SysBreakpoints table. You can find those tables in the SQL Management Studio or in the AOT under System Documentation -> Tables. This is useful to know when you get ‘ghost-breakpoints’. My debugger started showing me older breakpoints from classes that were running … Continue Reading

Testing code on client/server

  • September 25, 2010
  • 0 Comments

When you quickly want to test some code I often write some test-code in a small job. When you execute the code in this job, it will be executed on client-side. A colleague of mine asked me if he could test the same job while running on server-side. Wen you quickly want to test the … Continue Reading

Belgian Dynamics Community – Connection Day May September 30, 2010

  • September 17, 2010
  • 0 Comments

Yesterday I subscribed to the Belgian Dynamics Community connectionday in september 30, 2010. I’ll attend the Ax-track (obvious) with some of my colleagues / friends. The Agenda for the Ax-track: 18:30 – 19:15 General keynote track – The ins and outs of process optimization with SureStep 2010. Vincent Bellefroid, Plataan Most of us may have … Continue Reading

Loop all tables

  • September 16, 2010
  • 1 Comment

There is a simple trick to loop all tables that are available in Ax. Just use the Dictionary-class that contains all information about tables. Small example to list all tablenames + their corresponding Id. 1 2 3 4 5 6 7 8 9 10 static void JeDoe_listTables(Args _args) { Dictionary dictionary = new Dictionary(); int … Continue Reading

Enterpris Portal – Tips & Tricks (part1)

  • September 9, 2010
  • 0 Comments

Ilearned something new from my colleague Koen Van Hauwenhuyse. He showed me 2 extra querystring parameters you can add tot the portal URL so the content will be shown different. The normal Url of the page: http://***/TSTReplacement.aspx?WCMP=TST The Url for the rolecenter-view of the same page: http://***/TSTReplacement.aspx?WCMP=TST&RUNONCLIENT=1 The Url for the same page without any … Continue Reading

Records with RecId 101090

  • August 4, 2010
  • 2 Comments

I was using the postload method of the HRMBenefitType-table to fill the description-field with language-sensitive description (from LanguageTxt). This works fine when I view the record, but not when I use a lookup. I’ve put a break-point on my postload method and noticed the recId (this.recid of the HRMBenefitType table). This is always the 101090. … Continue Reading

Best Practices – Technical Best Practices for Dynamics AX

  • June 28, 2010
  • 0 Comments

While surfing on the web about Ax Best-Practices I found the following link on Packt Publishing. I think this is a verry good list of things a Ax developer should do while programming. This article is a part of the book ‘Quality Assurance for Dynamics AX-Based ERP Solutions‘, maybe I’ll read it.

Enterprise Portal – titlebar issue (part 2)

  • June 25, 2010
  • 0 Comments

While I was checking my previous Enterprise Portal titlebar issue, me and my colleagues found a second bug. When you use a single quote (‘) in the PageTitle, the name of the Page Defenition object is displayed instead of the actual label with the singel quote. We couldn’t find a solution yet, but we’re still looking. Anyone … Continue Reading