[Ace of Database]

Example:

PHP код:

static void DD_StoredProcReturnRecordsetTest(Args _args)
{
    str     serverName      = "Server";
    str     baseName        = "Database";
    str     userId          = "UserId";
    str     userPassword    = "Password";
    CCADOConnection         cn;
    COM                     comCN;
    COM                     cmd;
    CCADORecordset          rs;
    int                     i;
    ;

    cn = new CCADOConnection();
    cn.open(
        "Provider=SQLOLEDB;"+
        "Data Source="      + serverName    +   ";" +
        "Initial Catalog="  + baseName      +   ";" +
        "uid="              + userId        +   ";" +
        "pwd="              + userPassword);

    comCN = cn.connection();

    cmd     = new COM("ADODB.Command");
    cmd.activeConnection(comCN);
    cmd.commandType(4);  //adCmdStoredProc, see ObjectBrowser in VBA  
    cmd.CommandText("spTestReturnRecordset");
    rs = new CCADORecordset(cmd.Execute());
    while (!rs.eof())
    {
        info(strfmt("%1", rs.fields().itemIdx(0).value()));
        rs.movenext();
    }

    cn.close();
} 


Sooner I was able to pass parameters to stored procedures in Axapta. But now I forget how to do it