SessionInformation.SqlStatementsExecuted() Method

Version: Available or changed with runtime version 4.0.

Gets the amount of SQL statements executed on the session, since the session started.

Syntax

SqlStatementsExecuted :=   SessionInformation.SqlStatementsExecuted()

Note

This method can be invoked using property access syntax.

Return Value

SqlStatementsExecuted
 Type: BigInteger
The amount of SQL statements executed on the session, since the session started.

Remarks

AL debugger also lets you to monitor the number of SQL statements executed. For more information, see Debugging SQL behavior.

Example

The following code gets the number of SQL statements executed and displays the number in a message.

var
    SqlStatementsExecuted : BigInteger;

begin

    SqlStatementsExecuted := SessionInformation.SqlStatementsExecuted();
    Message(Format(SqlStatementsExecuted));
end;

See Also

SessionInformation Data Type
Get Started with AL
Developing Extensions