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. Source : Hougaard.com Read more...
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…
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…
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. Bron : Gunnar's Blog Lees meer...
Recently I was creating a function to resize an image. The function itself was resizing the image perfectly, however, my file size was always at least the same size… I think I tried about 8 different pieces of DotNet code, always resulting in the same thing.…
If you want to display text that is stored in binary format in a report you would need to use looping and reading the content of the blob piece for piece. With .net Interop we can do this a lot better. The StreamReader class is ideal…
So here is the working solution for this, it enables you to read compressed & non-compressed BLOBs. I tested it with the Object & the Object Metadata Table. Bron : deV.ch – man vs. code Lees meer...