Monthly Archives: March 2006

Convert Axapta date type value to datetime type value in SQL Server

It is known that, in Axapta, date data type only contains values of day, month and year whereas in SQL Server, datetime data type contains values of second, minutes and hour as well.  So if you want to retrieve values … Continue reading

Posted in Axapta Development | Leave a comment

Read and alter registry settings in Axapta

Here is a sample code of increasing max. open cursors during run-time. But, please note that its purpose is only to show you how to read and write registry. If you encounter any open cursors problem, it is recommended to … Continue reading

Posted in Axapta Development | Leave a comment

Axapta build number

In Axapta, choose the option About Microsoft Business Solution-Axapta in the Help pull-down menu, you can see the Axapta build number information, e.g. Microsoft Business Solution-Axapta 3.0 Build # 1951.6710/514-320 SP4/OP023-196. What does it stands for?The first part 1951.6710 is … Continue reading

Posted in Axapta Development | Leave a comment

Tips on optimizing primary index in Axapta

Primary index plays an important role in gaining optimum performance in Axapta. The Primary Index of a table is the main index that is used to uniquely identify records in it. No duplicated values are allowed in this index. When … Continue reading

Posted in Axapta Development | Leave a comment

Development Features of Dynamics Ax (Axapta) 4.0

Digested from Microsoft specification: Common Language Runtime (CLR) InteroperabilityThe CLR Interop feature allows X++ developers to add CLR assemblies to the AOT and write X++ code that interoperates with objects in these assemblies. This provides a number of benefits:• Developer productivity … Continue reading

Posted in Axapta Development | Leave a comment

Pass complex data types to 3rd party DLLs in Axapta

If you are using third-party dll files, you may encounter a problem that you need pass a complex data types to or from the dlls, for example, struct, array etc.  There is an example to show you how to pass … Continue reading

Posted in Axapta Development | Leave a comment

Use resource files in Axapta

Axapta provides a very handy feature to allow developers to ship their solution with Axapta built-in image files. In Application Object Tree, you can find resources node. Select resources node and right click; select Create from File, specify the file … Continue reading

Posted in Axapta Development | Leave a comment