Stored Procedure is not running for all rows

filiz

Hi,
I am executing a stored procedure in Axapta code. That is my code;

server static ResultSet executeSqlStatement(str sqlStatement)
{
Connection c;
Statement s;
ResultSet r;

SqlStatementExecutePermission perm;

;

c = new Connection();
s = c.createStatement();
perm = new SqlStatementExecutePermission(sqlStatement);

perm.assert();

s.executeUpdate(sqlStatement);

return r;
}


When I execute this code in SQL Server Query Analyzer, it's working for all rows, but when I execute in Axapta it is working just 41 rows. Stored procedure is including update command.

What is the problem. Is there any solution, any idea about this ?