Get SQL statement of your X++ Query

Hi All,
This blog will help us to get the SQL statement of your X++ query.

generateonly - you need to extend your x++ select with generateonly command that will generate the query before it execute.

Expected result 

X++ Code

Create one runnable class (TestGetSQLStatementOfXPlusPlusQuery) and add below code to test.

internal final class TestGetSQLStatementOfXPlusPlusQuery

{

    public static void main(Args _args)

    {

        VendTable   vendTable;

        select generateonly firstonly AccountNum, Party from vendTable

            where vendTable.AccountNum == 'Test123';

        info(vendTable.getSQLStatement());    

    }

}