Calling Stored Procedure in Axapta

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.