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.
Tag Archives: BLOB
Transact-SQL with SQL CLR
This blog post is for you if you’re looking for a way to get the text values of a BLOB field directly from a SQL query without having to modify the Business Central code base.
How to do Blob Storage in AL
Dealing with binary data in Business Central AL is a job for Temp Blob. In this video, I show to use the Temp Blob codeunit.
How to do Blob Storage in AL
Dealing with binary data in Business Central AL is a job for Temp Blob. In this video, I show to use the Temp Blob codeunit.
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:
Using Memo BLOB to Enable Huge Text
Generally speaking, enabling huge text fields in NAV is bad design because it encourages dumping unstructured data into the system. Reason Codes is an example of adding useful, structured data to the system.
But, every once in a while, there’s a legitimate need to write up a large chunk of text. The Notes functionality isn’t bad for that, but try adding that to a Report or a FastTab.
CALCFIELDS and BLOB in newer NAV versions
Just wanted to put this out there.
In older NAV versions you needed CALCFIELDS on a BLOB field before HASVALUE. Now you can ask for HASVALUE before CALCFIELDS.