Friday, May 25, 2012

"Error when executing direct SQL – SqlStatementExecutePermission”


While accessing SQL statements within AX world I came across an 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);

SOLUTION:
You can solve this issue easily, if you use the method marked as server static and call this method from the display method. 

2 comments:

I will appreciate your comments !

How to enable new Microsoft teams - Public Preview!

New Microsoft Teams is just AWESOME, quick but useful post below shows how you have this preview feature to make your life EASY!  Open Micr...