Junk value in BLOB

(0) Share

Report

Posted on by Community Member Microsoft Employee

I read a text document and then save it in a BLOB field in NAV. Reading function works fine and my problem is every time when I assign my text to BLOB field and read it back, it shows some junk values in the start of the text.

It is same value all the time and it always comes in the start of the text.

I check the text file and it does not contain any value like that and then I check the read message from NAV and it does not have the junk value also.

This only happen when I write my text to BLOB.

How to overcome this issue.

*This post is locked for comments

All responses (3)

Answers (1)

Suggested answer

4BzSoftware 6,071 on at

Like (0)

Report

RE: Junk value in BLOB

Hi Dushan,

I faced this problem when I developed Query and Excel Report tool, the email body. Just clear the BLOB field before update new text:

//S-002{

CLEAR("Email Body");

IF (gTxt_EmailBody.LENGTH > 0) THEN BEGIN

"Email Body".CREATEOUTSTREAM(lOuS_OutStream);

gTxt_EmailBody.WRITE(lOuS_OutStream);

END;

//S-002}
Verified answer

TharangaC 23,116 on at

Like (0)

Report

RE: Junk value in BLOB

or If you know the place of the junk value in the text then you can delete it with the following code

DELSTR(text, startPos,endPos);
Suggested answer

keoma 32,675 on at

Like (1)

Report

RE: Junk value in BLOB

check the blob field properties: it should by of (sub)type memo (not image/bitmap).

also try using compressed=no.