Relationship between BLOB fields and SetLoadFields()

It was great to hear a lot of positive comments after I published my previous post so I hope I won’t disappoint you and that this post will be at least as useful as the previous one. At the moment, we are experiencing some performance issues because of the BLOB fields.

Source : mmilince.com
Read more…

Dynamics 365 Business Central: handling BLOB fields on APIs

I’m not a big fan of using BLOB fields on the Dynamics 365 Business Central database, but there are many scenarios where you need to handle BLOBs inside the database directly.

As an example, imagine to have an application that handles different types of labels related to items and these labels are stored inside the Dynamics 365 Business Central database in a table called Labels. This table is defined as following:

Source : Stefano Demiliani
Read more…