SessionInformation.SqlRowsRead() Method

Version: Available or changed with runtime version 4.0.

Gets the amount of SQL rows read on the session, since the session started.

Syntax

SqlStatementsExecuted :=   SessionInformation.SqlRowsRead()

Note

This method can be invoked using property access syntax.

Return Value

SqlStatementsExecuted
 Type: BigInteger
The amount of SQL rows read on the session, since the session started.

Remarks

AL debugger also lets you monitor the number of SQL rows read. For more information, see Debugging SQL behavior.

Example

The following code gets the number of SQL rows read for the session and displays the number in a message.

var
    SqlRowsRead : BigInteger;

begin

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

SessionInformation Data Type
Get Started with AL
Developing Extensions