Microsoft Dynamics NAV (Archived)

How to add QR code to Table field?

(0) Share

Report

Posted on by JustZM

962

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)

JustZM 962 on at

Like (0)

Report

RE: How to add QR code to Table field?

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
Suggested answer

Suresh Kulla 50,080 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to add QR code to Table field?

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 962 on at

Like (0)

Report

RE: How to add QR code to Table field?

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
I Gusti Made Ari 3,594 on at

Like (0)

Report

RE: How to add QR code to Table field?

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

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,080 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to add QR code to Table field?

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
JustZM 962 on at

Like (0)

Report

RE: How to add QR code to Table field?

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

I Gusti Made Ari 3,594 on at

Like (0)

Report

RE: How to add QR code to Table field?

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