Microsoft Dynamics NAV 2009 Programming Cookbook电子书

Microsoft Dynamics NAV 2009 Programming Cookbook

Table of Contents

Microsoft Dynamics NAV 2009 Programming Cookbook

Credits

About the author

About the reviewer

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Strings, Dates, and Other Data Types

Introduction

Retrieving the system date and time

How to do it...

How it works...

There's more...

Logging changes and events

See also

Retrieving the work date

Getting ready

How to do it...

How it works...

There's more...

Populating date fields when a document is created

See also

Determining the day, month, and year from a given date

How to do it...

How it works...

There's more...

Determining depreciation

See also

Converting a value to a formatted string

How to do it...

How it works...

There's more...

Creating filters using other variable types

See also

Creating an array

How to do it...

How it works...

There's more...

Creating an address using the format address codeunit

See also

Creating an Option variable

How to do it...

How it works...

There's more...

Using Options in documents

See also

Converting a string to another data type

How to do it...

How it works...

There's more...

Incrementing a number series

See also

Manipulating string contents

How to do it...

How it works...

There's more...

Linking records with strings

See also

Using date formulas to calculate dates

How to do it...

How it works...

There's more...

Calculating reminder terms using date formulas

See also

2. General Development

Introduction

Repeating code using a loop

How to do it...

How it works...

There's more...

Using a WHILE loop

Using a REPEAT..UNTIL loop

See also

Displaying a Progress Bar

How to do it...

How it works...

There's more...

Processing only reports

See also

Checking for conditions using an IF statement

How to do it...

How it works...

There's more...

Testing multiple conditions

See also

Using a CASE statement to test multiple conditions

How to do it...

How it works...

There's more...

See also

Creating a function

How to do it...

How it works...

There's more...

Creating local or private functions

See also

Passing parameters by reference

How to do it...

How it works...

There's more...

See also

Referencing dynamic tables and fields

How to do it...

How it works...

There's more...

See also

Using recursion

How to do it...

How it works...

There's more...

See also

3. Working with Tables and Records

Introduction

Creating a table

How to do it...

How it works...

There's more...

See also

Adding a key to a table

How to do it...

How it works...

See also

Creating transactions to alter data

How to do it...

How it works...

There's more...

Calling code when performing a transaction

Catching errors when performing a transaction

See also

Validating data

Getting ready

How to do it...

How it works...

There's more...

See also

Retrieving a single record from the database

How to do it...

How it works...

See also

Using advanced filtering

How to do it...

How it works...

There's more...

See also

Retrieving data using FIND

How to do it...

How it works...

There's more...

See also

Adding a FlowField to a table

How to do it...

How it works...

There's more...

Determining the value of a FlowField

See also

Creating a SumIndex field

How to do it...

How it works...

There's more...

See also

Marking records for future use

How to do it...

How it works...

There's more...

See also

Clearing filters, keys, and values

How to do it...

How it works...

See also

Using temporary tables to store data

How to do it...

How it works...

There's more...

Storing records to process

See also

Retrieving data from another company

Getting ready

How to do it...

How it works...

See also

Merging records

Getting ready

How to do it...

How it works...

See also

Writing your own rollback routine

Getting ready

How to do it...

How it works...

See also

4. Designing Forms

Introduction

Obtaining input without a form

How to do it...

How it works...

There's more...

See also

Using the Form Generation Wizard

How to do it...

How it works...

There's more...

See also

Changing text appearance

Getting ready

How to do it...

How it works...

There's more...

See also

Preventing editable lookup forms

Getting ready

How to do it...

How it works...

There's more...

See also

Adding an editable field to a non-editable form

Getting ready

How to do it...

How it works...

See also

Creating a matrix form

How to do it...

How it works...

See also

Creating a wizard-style form

How to do it...

How it works...

See also

Designing a form based on a temporary table

How to do it...

How it works...

See also

Updating a subform from a parent form

How to do it...

How it works...

See also

Updating a parent form from a subform

How to do it...

How it works...

See also

5. Report Design

Introduction

Using the Report Generation Wizard

How to do it...

How it works...

There's more...

See also

Adding custom filters to the request form

How to do it...

How it works...

There's more...

See also

Setting filters when a report is loaded

How to do it...

How it works...

There's more...

See also

Creating a report to process data

How to do it...

How it works...

There's more...

See also

Displaying a check mark on a report

How to do it...

How it works...

See also

Dynamically showing Sections on reports

How to do it...

How it works...

There's more...

See also

Grouping data to display totals

How to do it...

How it works...

There's more...

See also

Adding page totals to reports

How to do it...

How it works...

There's more...

Display page X of Y

Getting ready

How to do it...

How it works...

There's more...

See also

Using virtual tables to loop through data

How to do it...

How it works...

There's more...

List of virtual tables in NAV

See also

Adding a watermark to a page

Getting ready

How to do it...

How it works...

There's more...

See also

6. Diagnosing Code Problems

Introduction

Using the debugger

How to do it...

How it works...

There's more...

See also

Setting breakpoints

How to do it...

How it works...

There's more...

See also

Using Code Coverage

How to do it...

How it works...

There's more...

Running Code Coverage from code

Handling runtime errors

How to do it...

How it works...

See also

Using Client Monitor to diagnose problems

How to do it...

How it works...

See also

Finding errors when using NAS

Getting ready

How to do it...

How it works...

There's more...

See also

Implementing Try / Catch / Finally

How to do it...

How it works...

There's more...

See also

7. Roles and Security

Introduction

Adding roles through the User Setup table

How to do it...

How it works...

There's more...

See also

Creating and assigning a security role

How to do it...

How it works...

There's more...

Leveraging the User Rights tool

See also

Using FILTERGROUP to restrict data

How to do it...

How it works...

See also

Checking for user-assigned roles

How to do it...

How it works...

See also

Checking Active Directory groups

Getting ready

How to do it...

How it works...

See also

Using security filters

Getting ready

How to do it...

How it works...

There's more...

See also

Field-level security

Getting ready

How to do it...

How it works...

There's more...

See also

Assigning menu suites based on company

How to do it...

How it works...

See also

Ending an idle session

How to do it...

How it works...

There's more...

Automatically adding users to NAV

Getting ready

How to do it...

How it works...

There's more...

See also

Hiding values in Zoom

How to do it...

How it works...

There's more...

See also

8. Leveraging Microsoft Office

Introduction

Using the style sheet tool

Getting ready

How to do it...

How it works...

There's more...

See also

Sending data to Microsoft Word

Getting ready

How to do it...

How it works...

There's more...

See also

Sending an e-mail from NAV through Outlook

Getting ready

How to do it...

How it works...

There's more...

Sending an HTML formatted e-mail

Exporting data using the Excel buffer

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a data connection from Excel to NAV

Getting ready

How to do it...

How it works...

There's more...

See also

Creating an InfoPath form with NAV data

Getting ready

How to do it...

How it works...

There's more...

See also

Instant messaging using Office Communicator

Getting ready

How to do it...

How it works...

There's more...

See also

Creating charts with Visio

Getting ready

How to do it...

How it works...

There's more...

See also

9. OS Interaction

Introduction

Using HYPERLINK to open external files

How to do it...

How it works...

There's more...

See also

Working with environment variables

How to do it...

How it works...

There's more...

ENVIRON for the RoleTailored client

See also

Using SHELL to run external applications

How to do it...

How it works...

See also

Browsing for a file

How to do it...

How it works...

See also

Browsing for a folder

How to do it...

How it works...

See also

Checking file and folder access permissions

How to do it...

How it works...

See also

Querying the registry

How to do it...

How it works...

There's more...

See also

Zipping folders and files within NAV

How to do it...

How it works...

See also

10. Integration

Introduction

Flat file exchange using dataports

How to do it...

How it works...

There's more...

See also

Sharing information through XMLports

How to do it...

How it works...

There's more...

See also

Manually writing to and reading from files

How to do it...

How it works...

There's more...

See also

Creating a web service

How to do it...

How it works...

See also

Consuming web services

How to do it...

How it works...

See also

Sending data through FTP

Getting ready

How to do it...

How it works...

There's more...

See also

Printing reports to PDF

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a custom NAS handler

Getting ready

How to do it...

How it works...

See also

Writing your own automation using C#

How to do it...

How it works...

See also

Using ADO to access outside data

How to do it...

How it works...

There's more...

11. Working with SQL Server

Introduction

Creating a basic SQL query

How to do it...

How it works...

There's more...

Other Types of SQL queries

See also

Adding the xp_ stored procedures

How to do it...

See also

Understanding SIFT tables

How to do it...

How it works...

See also

Using SQL Profiler

How to do it...

How it works...

See also

Displaying data from a SQL view in NAV

How to do it...

How it works...

There's more...

See also

Figuring out who is blocking whom

How to do it...

How it works...

There's more...

Another way to find deadlocks

See also

Setting up a backup plan

How to do it...

How it works...

See also

Scheduling NAV tasks from SQL Server

How to do it...

How it works...

There's more...

See also

12. The RoleTailored Client

Introduction

Creating a page using the Page Generation Wizard

How to do it...

How it works...

There's more...

See also

Building a Role Center

How to do it...

How it works...

There's more...

See also

Changing default filter columns

How to do it...

How it works...

There's more...

See also

Building the report layout

How to do it...

How it works...

There's more...

See also

Interactive sorting for reports

How to do it...

How it works...

There's more...

See also

Displaying a graph on a report

How to do it...

How it works...

There's more...

See also

Displaying a .NET add-in on a page

Getting ready

How to do it...

How it works...

See also

Index