Junk value in BLOB

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

keoma 32,729 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.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 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);

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 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}

Was this reply helpful? Yes No