Selecting Records from an External Database

Submitted by Nathan Clouse on 08/08/11.

Last modified: 

02/11/17

Tags: 

Class(es): 

To select records from the current AX database or any external database, you can do the following:

server static void testSQLStatment(Args _args)
{
    DictTable                       dictTable;
    Connection                      connection;
    Statement                       statement;
    str                             sql;
    ResultSet                       resultSet;
    SqlStatementExecutePermission   perm;
    ;

    dictTable = new DictTable(tableNum(InventBatch));
    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();
    }
}

 

If you are selecting from an external database, there is no use for the DictTable and you can use proper names from that database.