Blob field in Record Link table

(0) Share

Report

Posted on by MiguelRospa

Hi,

I am generating email notifications when notes are inserted, modified or deleted. In the events 'OnAfterInsertEvent' and 'OnAfterModifyEvent' I can retrieve the text of the note using the following code:

Rec.Note.CreateInStream(InStream, TEXTENCODING::UTF8);
CommentRec := TypeHelper.ReadAsTextWithSeparator(InStream, TypeHelper.LFSeparator);

The problem is that in the 'OnBeforeDeleteEvent' and 'OnAfterDeleteEvent' events the text of the note seems to be already deleted, since the code above returns me an empty string. I have used the event recorder and I don't see any interesting events to which I can subscribe. Any suggestion?

Regards.

I have the same question (0)

All responses (6)

Answers (0)

Andy Sather Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

I will open this up to the community in case they have something to add.

Was this reply helpful? Yes No
MiguelRospa 95 on at

Like (0)

Report
Copy link

Link copied!

Hello, thanks for answering. I have tried to register on the website you indicate but I have not received any email to complete the registration. Could you help me?.

Was this reply helpful? Yes No
Inge M. Bruvik 1,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

In the delete triggers you should use xrec and not rec.

xrec holdes the value of the record that is about to be deleted. Rec is the current record.

This is a good video to watch to understand xrec

www.youtube.com/watch

Was this reply helpful? Yes No
MiguelRospa 95 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for the answer Inge, but I know how xRec and Rec work. The function header is as follows:

[EventSubscriber(ObjectType::Table, Database::"Record Link", 'OnAfterDeleteEvent', '', false, false)]
local procedure OnAfterDeleteEvent(RunTrigger: Boolean; var Rec: Record "Record Link");

and all fields except the Blob type can be accessed. It seems that before the OnBeforeDeleteEvent is executed this field has already been cleared and unfortunately there doesn't seem to be another event that I can subscribe to.

Was this reply helpful? Yes No
Inge M. Bruvik 1,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sorry, i did not realize that you worked in an event trigger. I thought you worked with a table trigger.

In the OnAfterDelete event you should expect the field to be empty. But in the OnBeforeDelete event it should be possible to get hold of the value that is about to be deleted.

What version are you on ?

Was this reply helpful? Yes No
MiguelRospa 95 on at

Like (0)

Report
Copy link

Link copied!

That's what I think, that in the OnBeforeDelete event it should be possible to access the blob field, but it is the only field that seems to have been deleted before the event has been executed.

Version: Business Central 16.1

Kind regards.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Blob field in Record Link table

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Blob field in Record Link table

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates