Plataan

Forms based on temporary tables

Few days ago, I was working on some development for a new granule in Dynamics-nav 4.0. For the processing of some functionality I made use of a temporary table. This looked like the best and fastest way to process these data.
Few moments later I wanted the data in these table to be shown to the user. It didn't take me long to realise that showing data in a temporary table on a form is not the easiest thing to do in Dynamics-nav. It involves the implementation of form triggers to trick the form into displaying non-database table information. The results of this technique are not really superbe.

I was also wandering if this was a good option as in Dynamics-nav 5 series the architecture is changed towards 3-tier. Writing code on forms is not really for the best in this architecture.

On the other hand temporary tables are very useful and it would be nice to use these to populate forms with data.

Guess what?
In Dynamics-nav 5.0 forms can be mapped to temporary tables! This by using a new property on the forms: "SourceTableTemporary" property which needs to be set to yes.

Result?
No more form trigger code needed to populate forms with data from temporary tables.

Changes between SqlServer 2000 and 2005

Here you will find a list of changes in behaviour between Sql Server 2000 and Sql Server 2005: http://msdn2.microsoft.com/en-us/library/ms143532.aspx

It shows you a list of features that are no longer supported in Sql Server 2005:

Discontinued Database Engine Functionality in SQL Server 2005	Discontinued Database Engine functionality in this release.
Deprecated Database Engine Features in SQL Server 2005	Deprecated Database Engine features in this release.
Breaking Changes to Database Engine Features in SQL Server 2005	Database Engine feature changes that might require changes to applications.
Behavior Changes to Database Engine Features in SQL Server 2005	Other changes in behavior to database features in this release.

Dynamics NAV 4.0 SP3

Microsoft Dynamics NAV 4.0 SP3 is now available for group 2 countries. You can download the service pack at the PartnerSource website.

This service pack includes fixes for more then 280 issues and Business Analytics Basic is now included for Sql Server 2000 and 2005. Only BA Basic of NAV 4.0 SP3 will work with SQL 2005. The version of BA Advanced that will work with SQL 2005 will be released with NAV 5.0 which is due next year.

For more information on this read the Download product_release_note_nav_w1_40_sp3.zip  or go to the related PartnerSource page.