[Axapta-Knowledge-Village] Fw: how to pass in and out parameter to StoredProcedure usin X++ in ax(urgent issue)

[kancheti babu]

--- On Thu, 24/9/09, kancheti babu <kashok_1...@yahoo.co.in> wrote:

From: kancheti babu <kashok_1...@yahoo.co.in>
Subject: how to  pass in and out parameter  to StoredProcedure  usin X++ in 
ax(urgent issue)
To: "axapta" <Axapta-Knowledge-Village@yahoogroups.com>
Date: Thursday, 24 September, 2009, 11:20 AM


Hi All,

#yiv236025333 v\00003a* {
}
#yiv236025333 o\00003a* {
}
#yiv236025333 w\00003a* {
}
#yiv236025333 .shape {
}

#yiv236025333 st1\00003a*{}


Greetings of the day!

//StoredProcedure to fetch the data from 
Axapta Database  and insert into external database i am 't able to pass output 
parameters to storedProcedure in X++ using ccado classes 
plz tell how to pass output parameters for sp?

 
   static void DD_StoredProcReturnRecordsetTest(Args _args)
{
    str     serverName      = "192.168.1.109";
    str     baseName        = "Dynamics1";
    str     userId          = "sa";
    str     userPassword    = "sa ";
    CCADOConnection         cn;
    COM                     comCN;
   
 COM                     cmd;
    COM                     param, params;
    COMVariant              emptyParam;
    COMVariant              result;
    CCADORecordset          rs;
    str                     parameter;
    ;

    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(1);  //adCmdText, see ObjectBrowser in VBA
    parameter = "Parameter
 value";

    cmd.CommandText(strfmt("exec spTestReturnRecordset '%1'", parameter));

    rs = new CCADORecordset(cmd.Execute());
    while (!rs.eof())
    {
  /*  while( !CCADORecordSet.EOF() )
{
CCADOFields = CCADORecordSet.fields();
CCADOField = CCADOFields.itemIdx(0);
value = strrtrim(CCADOField.value());
print value;

CCADORecordSet.moveNext();
}

ccadoCon = new CCADOConnection();
> strCon = "Driver={SQL Server};Server= xx;Database= xx;";
> strCom = "select * from SalesTable";
> _ccadoCon.connectionString(strCon);
> _ccadoCon.open();
> _ccadoCom = new CCADOCommand();
> _ccadoCom.activeConnection(_ccadoCon);
> _ccadoCom.commandText(strCom);
> _ccadoRSet = _ccadoCom.execute();
> while(!_ccadoRSet.EOF())
> {
> //here, how can i control the CCADORecordSet
 "ccadoRSet",
> //so i can access the resultset,
> //except for value = _ccadoRSet.fields().itemName("SalesID").value();
>
> }

CCADORecordSet.close();
CCADOConnection.close();*/
        info(strfmt("%1", rs.fields().itemIdx(0).value()));
        rs.movenext();
    }

    cn.close();
}


thanks,

Ashok,
kashok_1...@gmail.com





       Yahoo! India has a new look.  Take a sneak peek.


      Yahoo! India has a new look. Take a sneak peek http://in.yahoo.com/trynew