Dynamics 365 Business Central: Get the amount of SQL rows read and the amount of SQL statements executed on the session via AL – SessionInformation Data Type

Today I want to share a mini tip about Business Central. How to get the amount of SQL rows read and the amount of SQL statements executed on the session via AL.

As you might, As of Business Central April 2019, the AL debugger also offers the capability to examine your AL code’s effect on the Business Central database.

Source : Dynamics 365 Lab
Read more…

When and Why I Avoid WITH Statements in C/SIDE

On a regular basis (but not regular enough to remember all the subtleties involved), I need to explain to people why I think using the WITH statement in C/SIDE is potentially a bad idea. This blog post gives me something to refer them to, and to occasionally remind myself of my reasons.

Source : ZEN & THE ART OF C/SIDE DEVELOPMENT
Read more…

Changes in C/AL Behaviour C/AL Statements in Nav 2016

The following table lists the summary of new, removed, or changed C/AL statements in Microsoft Dynamics NAV 2016. Will come with more details in my later posts. Statement Description FOREACH New statement. Iterate through a .NET Framework collection or array. BREAK New statement.

Bron : Ashwini Tripathi
Lees meer…