Join Two Tables at Run Time

Join Two Tables at Run Time

static void theAxapta_JoinTables(Args _args)
{
    Query                     query;
    QueryBuildDataSource      queryBuildDataSource1,
                              queryBuildDataSource2;
    QueryBuildRange           queryBuildRange;
    QueryBuildLink            queryBuildLink;
    ;
    // Create a new query object
    query = new Query();
    // Add the first data source to the query
    queryBuildDataSource1 = query.addDataSource(tablenum(CarTable));
    // Add the range to this first data source
    queryBuildRange = queryBuildDataSource1.addRange(fieldnum(CarTable, ModelYear));
    // Add the second datasource to the first data source
    queryBuildDataSource2 =   queryBuildDataSource1.addDataSource(tablen
    um(RentalTable));
    // Add the link from the child data source to the
    //parent data
    source
    queryBuildLink = queryBuildDataSource2.addLink(fieldnum(CarTable,
    CarId),fieldnum(RentalTable, CarId));
}
Note:
This process (query through X++ code) is very similar to create a query directly through AOT node.
AOT -> Query -> Right Click -> New Query
I would suggest first create a query through query node, than go for this code.


-Harry

Simple Dialog Box in Axapta 2012

Simple Dialog Box in Axapta 2012

Hi Folks,

The following example displays the dialog box and prints the value entered to the screen.

Code:

static void theAxapta_DialogBox(Args _args)

{

dialog              dialog;

dialogGroup    dialogGroup;

dialogField      dialogField;

;

dialog              = new Dialog("Simple Dialog");

dialogGroup    = dialog.addGroup("Customer");

dialogField      = dialog.addField(extendedTypeStr(custAccount));

if (dialog.run())

{

print dialogField.value();

pause;

}

}

Output:

Note:

    1.   The dialog.run() method returns true if OK is clicked, and false if Cancel is     clicked.

    2.   Dialog Group is used to group dialog fields which are logically same.

-Harry