SqlStatementExecutePermission Class

Definition

public ref class SqlStatementExecutePermission : Microsoft::Dynamics::Ax::Xpp::CodeAccessPermission

[Microsoft.Dynamics.Ax.Xpp.KernelClass]
public class SqlStatementExecutePermission : Microsoft.Dynamics.Ax.Xpp.CodeAccessPermission

[<Microsoft.Dynamics.Ax.Xpp.KernelClass>]
type SqlStatementExecutePermission = class
    inherit CodeAccessPermission

Public Class SqlStatementExecutePermission
Inherits CodeAccessPermission

Inheritance

Microsoft.Dynamics.AX.KernelInterop.ProxyBase

XppObjectBase

CodeAccessPermission

SqlStatementExecutePermission

Attributes

KernelClassAttribute

Remarks

This class is designed to check permissions for specific APIs. For a list of all protected APIs, see Secured APIs. You must call the assert method on the same tier, usually the server tier, that the corresponding CodeAccessPermission::demand method is called on before the protected API is executed. Call a method on the server tier from one of the following: a server static method, or a class instance method that is set to run on the server by using the RunOn class property

This example performs an SQL query on the CustTable table, which runs on the server. The result of the query is stored in the _resultSet object. The assert method is called to declare that the code can then instantiate the AsciiIo class that is used to read and write data to a file.

server static void main(Args _args) 
{ 
    DictTable  _dictTable; 
    Connection _connection; 
    Statement  _statement; 
    str        _sql; 
    ResultSet  _resultSet; 
    SqlStatementExecutePermission _perm; 
    _dictTable = new DictTable(tableNum(CustTable)); 
    if (_dictTable != null) 
        { 
           _connection = new Connection(); 
           _sql = strfmt( "SELECT * FROM %1", _dictTable.name(DbBackend::Sql) ); 
           _perm = new SqlStatementExecutePermission(_sql); 
           // Check for permission to use the _statement. 
           _perm.assert(); 
           _statement = _connection.createStatement(); 
           _resultSet = _statement.executeQuery(_sql); 
           // End the scope of the assert call. 
           CodeAccessPermission::revertAssert(); 
        } 
}

Constructors

Fields

Methods

Applies to