Tabax 0.3.2

download
Changes:

• AxPath: use of primary key of the record instead of recID
  
• French localization (thanx to Romain Gasnier)
  
• If tabax can not find it's resources on disk it tries to download them from Ax resources (useful for Ax 4 installations)

Unwanted fields fetching when selecting by unique index

UPD: Sorry, EmplTable is not good example - because of cache enabled. But this behavoiur is tested with a specially created table with CacheLookup==None.

Last friday i was optimizing a form with a lof of display fields with an implementation like the following:

display EmplName emplName()
{
 return EmplTable::find(this.EmplID).Name;
}

The one of sources to increase performance of such code is to select only fields which will be used lately. So I have replaced this code with the following:

display EmplName emplName()
{
 return this.EmplID ?
        (select Name from EmplTable
             where EmplTable.emplID==this.EmplID).Name
        :
        "";
}

but when I enabled SQL tracing, I found, that this code producess select with ALL fields of EmplTable.
It was strange... With a great help of my co worker, i've found the following:

• when there is only fields of any unique index in the where condition, all fields are fetched
  
• when there is an extra field in the condition, only required fields is selected (and the extra fields in where)
• So I converted previously mentioned methods to the following:
  

display EmplName emplName()
{
 return this.EmplID ?
        (select Name from EmplTable
             where EmplTable.emplID==this.EmplID
                     &&
                     EmplTable.recID
          ).Name
        :
        "";
}

TabaxLite

TabaxLite is a stripped down version of Tabax for end users.
It is focused solely on the window management and does not require any external component

Hosting the Windows Workflow Foundation designer

Windows Workflow Foundation (WF) is the new MS technology. It comes with .NET framework 3.0.

It is interesting that workflow designer can be hosted by any app (here is an example).

And maybe someone can make an ActiveX which can be hosted by Axapta form (here is an example of ActiveX control implemented in C#)

Sending attachments using the "mailto:" protocol

It works with Outlook at least. I think this example job is enough

static void Test_MailTo(Args _args)
{
   str recepient='mbelugin@gmail.com';
   str subject = 'Test';
   str attachment = @'c:\AUTOEXEC.BAT';
   str url = strFmt(
       'mailto:%1?Subject=%2&attachments=""%3""',

       recepient,
       subject,
       attachment
   );
;
   WinApi::shellExecute(url);
}

My first attempt to make a screencast

This screencast is showing TabaxLite in action.

setPrefix

The first line which I always write at the start of the 'run' method in a RunBase descenant is:

setPrefix(this.caption());

Settings prefixes is very useful for detect causes of errors later.

There are also very useful macros: PrefixField, PreFixFieldValue

For example, this code will set prefix to the: ": _item.itemID"

void processInventTable(InventTable _item)
{
;
    setPrefix(#prefixField(_item, itemID));
    ...

BTW, I think it will be also great to have a good logging system in Ax, infolog is not enough

Tabax v 0.3

download (87k)

After the long period of beta stage, the new release of Tabax is out.


This release introduces several new features which will be very useful for developers and end-users

First of all, it works under version 4 of Dynamics Ax.

Second, it introduces the Tabax Plugin API which allows developers to increase functionality of Tabax sufficiently.

There is a plugin for Tabax (in the tabax archive) to integrate AxPath with your system: so, if you install this plugin, you can click on AxPath links in browsers and email clients and go to specific location in code or specific record in the database (thank to AndyD for this functionality).

Ivan Kashperuk has developed a great plugin named RecentWindows which I use heavily. If you close some window, it allows to reopen it quickly.

Also, Ivan added a very useful feature to Tabax: if You press the 'Edit current field' toolbar button, while holding Ctrl and Shift down, Tabax will open a table field or data method related to the currently selected form field.

I have added similar fuctionality to the 'cross referebces' buton - now You can press it while working with form, and you will see cross refereces for the fireld related to the active control.

There are also some minor bugfixes and enhancements in this release

AxPath is supported by axaptapedia

So you can create links to AOT items in Axaptapedia using regular link syntax and if you have Tabax 0.3 rc 1 installed, you can navigate them.

Thanks to Andrew Jones!

• about AxPath


• download Tabax RC1

DLR & X++

About a week ago Microsoft has announced the new technology named DLR. As far as I know, this is a layer for dynamic languages support on top of .NET framework. I watched the very interesting video where integration of Python, Ruby and JScript is shown.

But what can it give to Dynamics Ax?

I think X++ have some features of dynamic languages.

For example, method identification is being done via method names, not some kinds of method ids (i.e. virtual methiod table indexes like C++). If you write code like

MyClass x;
;
x.myMethod();

compiler checks that class MyClass have method myMethod, runtime checks, that object x has method myMethod, but run time does not check whether x is instance of MyClass.

So you can write something like

MyOtherClass y=...;
Object o=y;
MyClass x=o;
;
x.myMethod();

the code will be executed successfully if MyOtherClass have method myMethod, even if MyOtherClass and MyClass have no common superclass.

Such tricks are used with forms (for example ; Tabax plugin SDK is using it also to provide compiler checks for tabax service methods usage).

So if Microsoft is planning to move Dynamics Ax to .NET platform, they should provide support for such behaviour for the backward comapatibility.

I think the work being done on DLR can be used in such case. Jim Hugunin, architect of DLR and and the author of IronPython says (see video mentioned above), that this implementation of the Python language outperform original C implementation (CPython) and runs 2 times faster on standard benchmarks. He also pays extremely high attention on backwards compatibility (for example, you can not use .NET object methods in IronPython code until you place "import clr" statement in your code).

I think when this job will be done and authors of DLR will find and mitigate dynamic languages problems in DLR and SilverLight, the result of the job can be used in the future dynamics products.

PS. I played some time with IronPython and found though it have pretty good perormance in requires a lot of time to initialize an engine and load a script.

Tabax 0.3 rc 1:

download (80K)

changes:

• fixes bugs in AxPath


• AxPath browser integration plugins is in archive in the extras folder


• Plugin SDK documented

AxPath integration with browser email etc

With great help of AndyD, Tabax now have an integration with browser and other tools. For example you can send a link to the specific purchase order via outlook, and when the link will be clicked, user will see purchase order you linked to.

You can also link to the specific parts of code. For example here tabax checks your access to development environment when you are navigating AOT link.

How to make it work:

• download the latest beta of Tabax
  
• Install Tabax and Plugin SDL
  
• download and install AxPath plugin. Run register.bat
  

SYS_ExpressionQueryBuilder

SYS_ExpressionQueryBuilder is an ExpressionBuilder for queries. Read more @ axaptapedia

    InventTrans inventTrans;
    QueryRun qr = SYS_ExpressionQueryBuilder::construct()
        .dataSource(tableNum(InventTrans))
            .count(fieldNum(InventTrans, RecID))
            .groupBy(fieldNum(InventTrans, ItemID))
            .between(fieldNum(InventTrans, DatePhysical), 01012006, 31122006)
            .matches(fieldNum(InventTrans, Qty), '<0')
 
        .exists(tableNum(InventDim))
            .link(fieldNum(InventTrans, InventDimID),
                  fieldNum(InventDim, InventDimID))
            .matches(fieldNum(InventDim, InventLocationID), condition)
    .run();
;
  while(qr.next())
    {
        inventTrans = qr.get(tableNum(InventTrans));
        info(strFmt('%1: %2', inventTrans.ItemId, InventTrans.RecId));
    }

Infolog stack trace

This extension allows to see stacktrace of infolog items and navigate through call stack. read more @axaptapedia

Tabax 0.3 beta 3

Starting a beta stage of the new Tabax version (download)

What's new since 0.2.x:

• Works with Ax 4 (icons are in tabax.ax4 they should be copied to "C:\Program Files\Microsoft Dynamics AX\40\Client\Share\Include\tabax")
  
• User interface can be localized (it is translated already to Russian and Spanish (the last by Manel Querol (Mkz) from http://www.TrucosAx.com))
  
• windows management (enable "fit maчimized" in setup and your window maximization will be emulated with fitting)
  
• tab width setup (maximal width, minial width and "Tabs have same size")
  
• Plugin SDK (it's only first small step)
  
• Ivan Kashperuk added the "Open table field" functionality to the "Edit current field" button
  
• Autosize: tabax don't let to change it's size
  

Tabax 0.2.15 -- fit mazimized windows

homepage

download (30K)

There are two changes:
1. "Fit maximized windows" setting added -- thanks AdnyD
2. Bug in table browser removed -- thanks Ivan Kashperuk

One of tabax users asked for the "Fit maximized windows feature". In you enable it tabax will fit window to the client area of Ax main window when detect maximization of some inner window.

I think, everybody do not like the following Ax behaviour: when you maximize window (for example code editor) and then open child window, the first winow change it's size. The new Tabax feature prevents it behaviour - it just normalize all maximized windows and fit them to the maximal size they can get without some parts being hidden. So when new window is displayed, prevoius window do not change it's size.

What do you think about this feature?

Podcasts

I am now in pause between the two jobs. So almost every day I am walking through the nearby forest park with my child. She is sleeping and I have about three hours to do something interesting or useful. Snowflakes falling down do not allow me to read on paper or my pocket pc, but I can listen podcasts or webcasts.

The additional reason to do such things is to learn spoken english. For example when MS contacted me via phone on the SQL injection hole i've found (BTW i have tried to reproduce it on Ax4 and it is still here) I was not able to understand almost anything from what they have spoken.

So I need to train...

The first candidate to listen is the list of webcasts on channel 9 tagged with "Dynamics" because it is an interesting topic to me.

It is very useful, but have some disadwantages:

• the files are very big - I need soundtrack only
  
• my mp3 player can not play wmv smoothly (and it plays them only after renaming them to .wma) - I am forced to use a Pocket PC
  
• I feel, I can get a slight Danish accent (it is nice, but I think not when mixed with Russian ;) )
  

So I am switched to other podcast named .NET rocks - an internet radio about Microsort .NET and related technologies. It is interesting for me, sounds quite professional and, I think, made with a clean American English.

Can you recommend me interesing podcasts in English?

Do you know something for extracting soundtrack from a wmv file?

PS. The latest ".NET rocks" show is with a Steve McConnell, the author of the "Code complete" book, recomended recently by MFP

Sidax 0.4 b 2

See page at axaptapedia for details. It is strongly recommended to upgrade beta0 to beta 1 or beta 2.

Python

Every programmer, ecpecialy one, which deals with some ugly language like X++ or BAAN 4GL should know some scripting language. Its a kind of practical and easy tool which allows you to write small programs quickly, in cost of performance.

My favorite is Python. It is nice, mature enough and widely supported (even my Pocket PC has an interpretter).

For example one task which I did with python a couple days ago is a preparation of data of the legacy system to load in Dynamics Ax. The source file consists of text lines, where data fields are separated with the piplene character ('|'). Some of data fields values contain pipeline character too. The first field of the line identifies type of the data (invenotory group or inventory item). The file was encoded using DOS (cp866) encoding. So there was 3 actions po perform:

• recode data to Windows encoding (cp1251)
  
• separate item data from inventory group data
  
• check for lines which pipeline in data
  

It was done by the following scipts:

1. Splitting files by data type and converting from DOS to Windows

src=open('input.txt',  'r')
dst = {'asl': open('inventory.txt', 'w'), 'ctl': open('group.txt', 'w')}
lineNo = 1
for line in src:
    type = line.split('|')[0]
    if type in dst:
        try:
            dst[type].write(line.decode('cp866').encode('cp1251'))
        except:
            print line
            print lineNo
    lineNo += 1

2. Checking for correctnes:

import sys
lineCount = 8
fileName = sys.argv[1] if len(sys.argv)>1 else 'inventory.txt'
for lineNo, line in enumerate(open(fileName, 'r')):
    if line.count('|')!=lineCount:
        print lineNo
        print line.decode('cp1251').encode('cp866')

As you can see it is readable and easy.

If you get interested, look at the following links:

• python.org -- python homepage
  
• dive into python -- python tutorial
  
• IronPython -- python for .NET (by MS employee)
  

Tabax 0.2.14: View query of the active datasource

A new version of tabax:

download (27K)

Now you can view the source of the query in the active datasource by simply holding Ctrl+Shift while pressing the 'Table browser' button (code by Ivan Kashperuk).

Also you can list all datasources on the active form and then browse the data by holding Shift while pressing the 'Table browser' button.