Book Image

Microsoft Dynamics NAV 2009 Programming Cookbook

By : Matthew Traxinger
Book Image

Microsoft Dynamics NAV 2009 Programming Cookbook

By: Matthew Traxinger

Overview of this book

Microsoft Dynamics NAV 2009 is a business management solution that helps simplify and streamline highly specialized business processes such as finance, manufacturing, customer relationship management, supply chains, analytics, and electronic commerce for small and medium-sized enterprises. ERP systems like NAV thus become the center of a company's day-to-day operations. When you learn to program in an environment like this it opens up doors to many other exciting areas like .NET programming, SQL Server, and Web Services.Microsoft Dynamics NAV 2009 Programming Cookbook will take you through interesting topics that span a wide range of areas such as integrating the NAV system with other software applications like Microsoft Office, creating reports to present information from multiple areas of the system, and so on. You will not only learn the basics of NAV programming, but you will also be exposed to the technologies that surround the NAV system such as .NET programming, SQL Server, and Web Services.The first half of the cookbook will help programmers coming to NAV for the first time by walking them through the building blocks of writing code and creating objects like tables, forms, and reports. The second half focuses on using the technologies surrounding NAV to build better solutions. You will learn how to write .NET code that works with the NAV system and how to integrate the system with other software applications like Microsoft Office or even custom programs. You will also discover some of the features of the Role Tailored Client including creating Pages and custom add-ins.
Table of Contents (18 chapters)
Microsoft Dynamics NAV 2009 Programming Cookbook
Credits
About the author
About the reviewer
Preface
Index

Designing a form based on a temporary table


You may not always have the luxury of being able to save all of the information you need to the database. At other times you may want to calculate data on the fly and present it to the user in a form. Temporary tables come into play here and there is a special way to show their data on a form.

How to do it...

  1. Follow the steps from the Using the Form Generation Wizard recipe in this chapter.

  2. View the form properties by pressing Shift + F4.

  3. Set the following properties on the form:

    Property

    Value

    SourceTableTemporary

    Yes

  4. Add a global function named LoadData.

  5. Add the following local parameters to the function:

    Name

    Type

    Length

    NoParam

    Code

    20

    NameParam

    Text

    50

  6. Add the following code to the function:

    "No." := NoParam;
    Name := NameParam;
    INSERT;
    
  7. Add the following code to the OnOpenForm trigger:

    AddCustomer('1', FIELDCAPTION(Name) + '1');
    AddCustomer('2', FIELDCAPTION(Name) + '2');
    AddCustomer('3', FIELDCAPTION(Name) + '3');
    
  8. Save and close the...