While accessing SQL statements within AX world I came across an
error which was really time consuming for me to get rid of.
error which was really time consuming for me to get rid of.
I created a method like this;
It got failed while executing statement and gave following error
” Error when executing direct SQL – SqlStatementExecutePermission” on
line resultSet
= statement.executeQuery(sql);
” Error when executing direct SQL – SqlStatementExecutePermission” on
line resultSet
= statement.executeQuery(sql);
SOLUTION:
You can solve this issue easily, if you use the method marked
as server static and call this method from the display method.
as server static and call this method from the display method.
