[development-axapta] Execute stored procedure in ax

[Tri Budianto]

hello everyone..

i have stored procedure in SQL server that i want to execute thru X++.
anyone have done it? in axapta 3.0 i've done it and it is succes, but when
i'm trying
the code in AX 4 SP1 it is failed.

here is my code :


server static void test2()
{
    Connection                      conn;
    Statement                       stmt;
    ResultSet                       rs;
    SqlStatementExecutePermission   perm;
    str                             sql;

    conn = new Connection();

    sql = "uspReportHPP 'dat', '2008-03-01', '2008-03-31'";
    perm = new SqlStatementExecutePermission(sql);
    perm.assert();
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);

    while(rs.next())
    {
        info(rs.getString(2));
    }
}
i would thanks for any help...

-- 
Best Regards,
Tri Budianto


[Non-text portions of this message have been removed]