AL

Oct 28

Hidden SQL queries in AL you (probably) want to avoid

Development of Business Central extensions is very much about the database communication, and as AL developers, we always control the...

Oct 22

if not IsEmpty then FindSet... again

Yes, I'm back again on this inexhaustible topic. The question of weather the call of IsEmpty before FindSet in AL can have a positive...

Oct 20

Covering indexes as an alternative to SIFT

In two of my previous blog posts I reviewed some pros and cons of the SumIndexField Technology (or SIFT) in Business Central. On the one...

Aug 5

SIFT

SIFT, which stands for Sum Index Flow Technology, used to be a know-how in the Navision database, a data structure that stored...

Jun 30

Navision legacy in AL: RecordLevelLocking

RecordLevelLocking function in AL is a heritage of the C/SIDE times and the Navision native database. In those old days when Navision...

Jun 9

Lock timeouts and deadlocks

A long time ago (in a galaxy far away) I published some blog posts with a deeper overview of the Business Central's ReadIsolation...

Jan 8

The case of a missing newline character. One almost detective story.

This almost detective story started when I was building a client app in Business Central which sent data to a JavaScript control add-in...