"Error when executing direct SQL – SqlStatementExecutePermission”

"Error when executing direct SQL – SqlStatementExecutePermission”

MCP · Azure DevOpsYour delivery board, readable by an agentMCP · DataverseOne consent, and the data layer opensMCP · Dynamics 365 F&OConnecting F&O to an agent Microsoft hasn’t documented

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. 

Previous article← Dynamics AX 2012: "Precision lost" warning message
Discussion

Ask a question or leave feedback

This is a review interaction. The WordPress version will store, thread and moderate comments.

Thanks — submitted for moderation in this review.
Search the whole site · Ctrl/⌘ + K