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 |
|
Parameters |
[[FindOptions] [FieldList |
FindOptions |
|
FieldList |
Field { , Field} | |
Field |
Aggregate (FieldIdentifier) | FieldIdentifier |
Aggregate |
|
Options |
[ |