O'Reilly logo

Microsoft Dynamics AX 2009 Development Cookbook by Mindaugas Pocius

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1. Processing Data

In this chapter, we will cover the following topics:

  • Creating a new number sequence
  • Renaming the primary key
  • Merging two records
  • Adding document handling notes
  • Using a normal table as temporary table
  • Copying a record
  • Building a query object
  • Using a macro in a SQL statement
  • Executing a direct SQL statement
  • Enhancing the data consistency check
  • Exporting to an XML file
  • Importing from an XML file
  • Creating a comma-separated value file
  • Reading a comma-separated value file
  • Deleting all company transactional data

Introduction

This chapter focuses on data manipulation exercises. Here, we will discuss how to work with query objects from X++ code. We will also discuss how to reuse macros in X++ SQL statements and how to send SQL statements directly ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required