torsdag den 29. april 2010

Refreshing (executeQuery) a calling form from the called form.

A feature that you often need when you work with code that is called from a form and manipulates data, is to be able to refresh the calling form to reflect the changes made, when the code has been run.

This could also be a form calling an other form, where data changes are made, in the called form, but the changes must be reflected in the calling form, when the called form is closed.

I have seen it done by making call back to a method on the calling form, that does the refresh.

You can however make the refresh from the CALLED form or code, using an args-object.

When a form calls an other form it is typically done via a menu item, and thus automatically an args object is passed to the called form.

The args object can carry a tablebuffer object that is acessed with the record method on the args object.

You can determine if the tablebuffer object is a formDataSource, and if so, you can instantiate a formDataSource-object on which you call the executeQuery-metod.

One example could be:

Form SalesTable
has a menuitembutton that calls Form SalesLine.

Form SalesTable has a display method that sums up data manipulated in Form SalesLine.
When closing form SalesLine we need Form SalesLine to re-execute the query in Form SalesTable and thus refreshing the data form SalesTable is showing.

This can be done by overriding the close method on Form SalesLine and putting the following code into it:

public void close()
FormDataSource fds; // Form data source object
SalesTable salesTable; // tablebuffer passed in args object

// Refresh calling form data source
salesTable = element.args().record();
if (salesTable.isFormDataSource())
fds = salesTable.dataSource();
if (fds)

The above shown can also be used in a main-method on a class, so that code in the class that manipulates data shown in a form, where the class is called via a menu-button on the form.

I thought of doing it with a common object, and putting the code in a method on the GLOBAL class, to make it useable everywhere from a single line of code, but the Axapta client (3.0) kept crashing when calling common.dataSource() :0(.

mandag den 26. april 2010

Don't override the tabChange-method on a tab.

Working on a Dynmics AX 4.0, I learned today (from a wizard-level colleague), that overriding the tabChange-method on a tab in a form in Dynamic AX/Axapta, disallows the usersetup of the tab and all of it's children.

My problem was that a customer complained that they were not able to make a user setup of the form and add fields to a tab and all tabpages below that tab on the PurchTable-form.

The customization:

public boolean tabChange(int fromTab)
boolean ok;

ok = super(fromTab);

if (ok)

return ok;

had been added to the tab.

Seing that the method call


was present in
pageActivated-method on the tabpage TabHeaderPostings in the SYS-layer (!),
I decided to remove the above customization.

onsdag den 21. april 2010

Useful function for left trimming 0's in a string.

A colleague of mine made this little function.
It strips leading 0's in a string.
The string may only be a 1000 characters long, but that can be modified by changing 1000 to an other value.

static TempStr strLtrim0(TempStr txt,str 1 trim = '0')
int i = strNfind(txt,trim,1,1000);
return i ? subStr(txt,i,1000) : '';