Plataan - Microsoft Dynamics - Learning & Competence Management Vincent Bellefroid Koen Stox Steven Renders Conny Schuddinck Steffie Alexiou
A blog about Microsoft Dynamics
Home Archives Subscribe Plataan website

« Changes between SqlServer 2000 and 2005 | Main | HOSTED Microsoft Dynamics and CRM »


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.

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


The comments to this entry are closed.

October 2011

Mon Tue Wed Thu Fri Sat Sun
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

Plataan Community

Visit us on LinkedIn Visit us on Facebook Visit us on Twitter