Tuesday, January 16, 2024

Execute SQL statement from X++

 Connection      connection;
        Statement       statement;
        str             query;

        connection = new Connection();
        statement = connection.createStatement();
        query = "update EnumValueTable set EnumValueTable.enumValue = '75'";
        new SqlStatementExecutePermission(query).assert();
        statement.executeUpdate(query);
        CodeAccessPermission::revertAssert();

No comments:

Post a Comment

Table browser URL in D365FO

Critical Thinking icon icon by Icons8