Small and medium business | Business Central, N...

How to edit blob field in Navision

(0) Share

Report

Posted on by yoheswaran

231

Hi,

I added six blob fields in setup screen, for all fields can we use get and set process. i tried for single field is there any option to write a code for all field in a single function.

Thanks in Advance.

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

That depends what is the source of the data you want to put in the fields.

Are you you important data from files or do you have other sources for your data?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,593 Super User 2025 Season 2 on at

Like (0)

Report

Hi, if this is a customization, you can add some code (function) to the OnValidate (Fields) Trigger to synchronize the other five values when one is entered.
More details: https://learn.microsoft.com/en-us/dynamics-nav/onvalidate--fields--trigger

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
yoheswaran 231 on at

Like (0)

Report

Is there any way to enter text in blob field on navision i tried with SetDescription and WorkDescription it's not working.

Thanks

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi you can try this code

procedure SetWorkDescription(NewWorkDescription: Text)

var

OutStream: OutStream;

begin

Clear("Work Description");

"Work Description".CreateOutStream(OutStream, TEXTENCODING::UTF8);

OutStream.WriteText(NewWorkDescription);

Modify();

end;

procedure GetWorkDescription() WorkDescription: Text

var

TypeHelper: Codeunit "Type Helper";

InStream: InStream;

begin

CalcFields("Work Description");

"Work Description".CreateInStream(InStream, TEXTENCODING::UTF8);

exit(TypeHelper.TryReadAsTextWithSepAndFieldErrMsg(InStream, TypeHelper.LFSeparator(), FieldName("Work Description")));

end;

Was this reply helpful? Yes No
yoheswaran 231 on at

Like (0)

Report

Thanks for the reply "TryReadAsTextWithSepAndFieldErrMsg" this function is not available in Type Helper codeunit in navision 2017

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

I have shared the code for an idea, how you can implement in your version.

you can follow that link

learn.microsoft.com/.../how-to--use-streams-to-write-to-text-files

learn.microsoft.com/.../how-to--use-streams-to-read-from-text-files

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,593 Super User 2025 Season 2 on at

Like (0)

Report

Hi, you can refer to the practice of Work Description.

And hope the following can give you some hints.

https://andreilungu.com/read-write-text-from-to-blob-fields-generic-way-nav/

Thanks.

ZHU

Was this reply helpful? Yes No