Monday, 21 March 2016

Range On Form



public void lookup()
{
    Query query = new Query();
    QueryBuildDataSource qbds,qbdsJoin;
    QueryBuildRange queryBuildRange;
    DirPartyTable   DirPartyTable;

    SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(VendTable), this);

    qbds= query.addDataSource( tableNum(VendTable));
    queryBuildRange = qbds.addRange(fieldNum(VendTable, VendGroup));
    queryBuildRange.value("TRANSPORT");
    sysTableLookup.addLookupMethod('name',true);
    sysTableLookup.addLookupfield(fieldNum(DirPartyTable,Name));

    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();


}




No comments:

Post a Comment

Excel data connector in AX7/D365

Excel data connector in AX7: Configuring and using the Excel Data Connector Add-in The Excel Data Connector add-in is built by usi...