Best Practice ‘Best Practices’ in MorphX Coding
I ran into this a while back while working in Dynamics AX 2012, and it just reinforces that you really need to think through your design when coding methods in MorphX.
First, a description of the scenario. A table has been created that will be used as a temporary (InMemory) table. There will be conditions where we want to do a find on that table to see if a record already exists, and if so, update a value based on some calculations performed.
The issue. By default, a "Best Practice" is to create a static method on the table called find that returns the record that you desire. The problem is, this is a static method that will look at the table in the database. Since this is a memory based table, we have nothing in the database to examine.
The resolution. An instance method on the table is needed. That way, the search will be done on the table buffer that is defined in your code (the instance), and not the database defined object.
I just wanted to bring this up as something to keep in the back of your mind as you develop. Scope and instance can really play a part in how you retrieve data, and this is something that a less experienced developer may run into on occasion.