Calling Stored Procedure in Axapta

mike_espina

Hi experts,

Can anyone help me on how to call an SQL2000 stored procedure in Axapta.

Thank you very much

Mike

kjærsgaard

Hi again Mike

Notice in the example below that I have not declared the parm1 and parm2 variables. In a realworld example it should be done, but I think you know that.

The general way to call Stored Procedures. The method in a class:

public void callStoredProcedure()
{
Connection con = new Connection;
Statement stmt = con.CreateStatement;
Resultset r;
Str execStr;
;

// sp_storedProcedure is the name of the stored procedure in the
// SQL-Server
execStr = strFmt("exec sp_storedProcedure %1 %2", parm1, parm2);
r = stmt.executeQuery(execStr);

// and then you eventually can iterate your resultset, r
}

I hope you can use the answer.