Some AX Kernel functions

Thanks to Ruslan for this link:

http://schunk.dk/DocWeb/kernel%20functions.html

Structuring the first installer

Here, we will build a simple installer which will install a very simple application which consists of an executable, a DLL Library and a user manual. These files will be copied to a specific directory and 2 shortcuts would appear, one in usual place in the Start Menu and other icon shortcut on the Desktop.

Let’s start by following these steps:
a. Writing a simple .wxs xml installer source code .
b. Compiling the source code
c. Building the MSI.

OCC Contd...Concurrency Model configuration

Administration/Setup/System/Concurrency Model Configuration

This is a new feature in Dynamics AX 4.0 to set global concurreny model for database changes. The settings can siginificanly affect database performance.

Global Concurrency Settings

Optimistic concurrency mode enabled per table

This setting, which is the default, enables individual tables to be configured to work under a specific concurrency mode. When this option is selected, the concurrency mode is initially set to optimistic concurrency for all tables, with a few exceptions. The table property OccEnabled can be changed for any table as appropriate.

Optimistic concurrency mode enabled globally

Enables optimistic concurrency mode for all tables.

Pessimistic concurrency mode enabled globally

Enables pessimistic concurrency mode for all tables.

Use the READ UNCOMMITTED transaction isolation level for all Microsoft SQL Server 2000 database reads - Can be used to reduce blocking for installations running on Microsoft SQL Server 2000 databases.

Log all UPDATE conflict exceptions

Writes all UPDATE conflict exceptions to the log. It's recommended to select this setting.

Wix Introduction and Features

WiX (Windows Installer XML) is a toolset that builds Windows Installation Packages from XML Source Code. It provides a command-line environment that developers may integrate into their build processes to build MSI (Microsoft Installer) packages. WiX is an open source project. This toolset is written in C#.

Pre-Requisites
.NET Framework (Required on Developer’s system).
WiX Binaries and SDK(Required on Developer’s system).

Note: The installation packages built with this toolset do not require any software to be installed on the target computer.

Features
Features and advantages of the toolset:
· Declarative approach
· Unrestricted access to Windows Installer functionality
· Source code instead of GUI-based assembly of information
· Complete integration into application build processes
· Possible integration with application development
· Support for team development, both in-house and third-party
· Free, open source

Dynamic Property on Query's DataSource Fields

1. Go to AOT/Queries
2. For e.g. AssetBudgetModel\DataSources\Assetbudget\fields click the data source right-click Fields, and then click Properties.
2. Set the Dynamic property to No.


Note
By default, the Dynamic property is set to Yes and returns all fields from the table, map, or view. This makes maintenance easier because you don't need to change the query if a field is changed in the underlying data source. However, restricting the fields returned by the query is better for performance because unused data is not returned to the client each time the query is run.