Tag Archives: statements

How to make an optimized query using direct SQL statements in X++.

In this post we are going  to show you how to achieve this. As a first step we are going to create a new class and  we will proceed as always declaring the variables we are going to use.

Macros in SQL statements.

One of the benefits to use Macros, is that it allows to specify  partial statements on X++ querry code, that can be reused in several parts along any application.