在AX中使用SQL语句

 

server static void JobSQL(Args _args)
{
    Connection  c;
    Statement   s;
    ResultSet   r;

    SqlStatementExecutePermission   permission;

    str         sql;
    str         gy;
    ;
    gy = "CreatedDate";

    sql = strfmt("select %1,sum(qtySched),count(recId) from ProdTable group by %2",gy,gy);
    permission  = new SqlStatementExecutePermission(sql);
    permission.assert();

    c   = new Connection();
    s   = c.createStatement();
    r   = s.executeQuery(sql);

    while (r.next())
    {
//        print r.getString(2);
//        print r.getDate(3);
        info(strfmt("%1  %2  %3",r.getDate(1),r.getReal(2),r.getString(3)));
    }

//    pause;
}

ps:该程序只能运行在Server 下可使用一个MenuItem去调用它，指定RunOn=Server