Book Image

Learning MS Dynamics AX 2012 Programming

By : Mohammed Rasheed, Erlend Dalen
Book Image

Learning MS Dynamics AX 2012 Programming

By: Mohammed Rasheed, Erlend Dalen

Overview of this book

<p>This tutorial has been carefully structured to guide you through the basic features of AX development and get you started as quickly as possible. With this book, you will soon be able to develop and maintain comprehensive management solutions to enhance your Dynamics AX 2012 application's performance. Starting with a tour of the development environment, you'll gain a deep understanding of Dynamics AX tools and architecture, before getting to grips with X++ for deeper customization. You will also learn how to search, manipulate, and integrate data.</p> <p>The practical examples in this book take you through sample AX development projects and help you learn to create forms, reports, menu&nbsp; items, menus, and navigation pages. The book also helps you work with MorphX. By the end of this book, you will have a better understanding of the inner workings of Microsoft Dynamics AX—making your development simpler and faster, and your applications fast, reliable, and robust.</p>
Table of Contents (21 chapters)
Learning MS Dynamics AX 2012 Programming
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Links
Debugger
Index

The select statement


One of the really great features of Dynamics AX as a development tool is the possibility to write embedded SQL. This basically means that you can write select statements that are controlled by the compiler and get results back directly to table variables.

The following list is taken from the SDK and shows the syntax for the select statement and the parameters allowed with the it:

Description

Syntax

SelectStatement

select Parameters

Parameters

[[FindOptions] [FieldList from]] TableBufferVariable [IndexClause] [Options] [WhereClause] [JoinClause]

FindOptions

crossCompany | reverse | firstFast | [ firstOnly | firstOnly10 | firstOnly100 | firstOnly1000 ] | forUpdate | noFetch | [forcePlaceholders | forceLiterals] | forceselectorder | forceNestedLoop | repeatableRead

FieldList

Field { , Field} | *

Field

Aggregate (FieldIdentifier) | FieldIdentifier

Aggregate

sum | avg | minof | maxof | count

Options

[order by, group by, FieldIdentifier [asc | desc] { ...