Microsoft Dynamics NAV (Archived)

How to add QR code to Table field?

(0) Share

Report

Posted on by JustZM

972

I followed the link https://dynamicsuser.net/nav/b/ara3n/posts/creating-qr-code-in-nav-2016 to generate a QR Code.

If I do not save QR code to local, is it possible I add QR code to table's field?

Best Regards,

JustZM

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

I Gusti Made Ari 3,608 on at

Like (0)

Report
Copy link

Link copied!

You can use Outstream to save the image to BLOB field.

FixedQRLine.QRCode.CREATEOUTSTREAM(PictureStream);

bitmap.Save(PictureStream,ImageFormat.Jpeg);

FixedQRLine.MODIFY;

Was this reply helpful? Yes No
JustZM 972 on at

Like (0)

Report
Copy link

Link copied!

Hi I Gusti Made Ari Permadi

Thanks for your reply. I followed your way, to add PictureStream as Outstream.

But I got one error when save the QRCode. Do you know how I can fix it?

Best Regards,

JustZM

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,278 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try this

DummyTempBlob@1012 : Record 99008535;

InStr@1010 : InStream;

DummyTempBlob.INIT;
DummyTempBlob.Blob.CREATEINSTREAM(InStr);
Bitmap.Save(InStr,ImageFormat.Jpeg);

FixedQRLine.QRCode.IMPORTSTREAM(InStr,'');
Bitmap.Dispose;

Was this reply helpful? Yes No
I Gusti Made Ari 3,608 on at

Like (0)

Report
Copy link

Link copied!

Check your .net variable properties, set RunOnClient property to Yes

Was this reply helpful? Yes No
JustZM 972 on at

Like (0)

Report
Copy link

Link copied!

Hi I Gusti Made Ari Permadi

I checked all net variable, they are all yes. But I found the error is Dynamics.NAV.Ncl. This one is not any variable in my code.

Hi Suresh Kulla

I followed your way, but I got an error about "IMPORTSTREAM"

It is a variable or function? If it is a variable, how I should define it?

However, even after delete code about "IMPORTSTREAM", I have same error when it is saving bitmap.

Best Regards,

JustZM

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,278 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What is your NAV Version? You need to define QRCode as MediaSet. If not you can try this with blob field.

I don't think you have added the code as I have described, create instream for a tempblob not on your field, create outstream for QRCode field and use COPYSTREAM function to copy instream to outstream.

Was this reply helpful? Yes No
JustZM 972 on at

Like (0)

Report
Copy link

Link copied!

Hi Suresh

My version is NAV2015.

How can i define QRCode as MediaSet. Yes, now, it is a blob field.

However, I guess right now, the main problem is still in bitmap.save(). I cannot save QR image to the InStream and OutStream because when I debug it, the code stop at bitmap.save()

But all DotNets' RunOnClient are yes.

Best Regards,

JustZM

Was this reply helpful? Yes No