close 
CustTable custTable;
    boolean   a = false; //this boolean a might be changed to true
    Query query;
    QueryRun queryRun;
    Querybuilddatasource qbds;
    QuerybuildRange qbr;

    Query = new Query();
    qbds = query.addDatasource(tablenum(CustTable));
    qbr = SysQuery::findOrCreateRange(qbds, (fieldnum(CustTable, AccountNum)));

    if (a == true)
    {
        qbr.value(queryvalue("DEMO-0001"));
    }
    else
    {
        qbr.value(queryvalue("DEMO-0002"));
    }
 
    QueryRun = new QueryRun(query);

    while (queryRun.next())
    {
        custTable = queryRun.get(tablenum(CustTable));
        info(strfmt("AccountNum %1", custtable.AccountNum));
    }
arrow
arrow
    文章標籤
    Dynamics AX D365 SQL
    全站熱搜

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄