1. Olan Knight
  2. PowerBuilder
  3. Sunday, 1 May 2022 02:03 AM UTC

PowerBuilder v12.1, b7055
PowerBuilder 2019R3
Windows 10 64 bit platform

I'd like to be able to generate QR codes from either version of PowerBuilder, and do so without paying massive amounts of money.
Is this possible? If so, how can I make QR codes happen.


Thanks,
Olan

Who is viewing this page
John Fauss Accepted Answer Pending Moderation
  1. Friday, 13 May 2022 02:01 AM UTC
  2. PowerBuilder
  3. # 1

** Update ** 

In a rare and unprovoked case of sanity and common sense, I have simply attached the zip file containing the Quricol Example PB application and accompanying MS Word document to this post. I will continue to make the same zip file accessible on the below link to my Google Drive, however.

** End of Update **

Here's a link to a publicly-accessible folder within my Google Drive:

   https://drive.google.com/drive/folders/1LlncaTHnsP53v7NqhwdQVbUHrAmDbHHK?usp=sharing

A zip file in this folder contains the QuricolExample PB application and a Word document that helps explain how to use the application and some tips to explain key points regarding the application's code.

Reply/comment to this post if you experience any issues and I'll try to help.

Attachments (1)
Comment
  1. Olan Knight
  2. Thursday, 19 May 2022 14:29 PM UTC
Thank you again, John!
  1. Helpful
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 12 May 2022 02:02 AM UTC
  2. PowerBuilder
  3. # 2

Olan - 

Have you determined how you're going to generate QR Codes?

I found a reference in another Q&A post about a DLL named Quricol that contains methods that are easily callable from a PB application, much like you would call a Windows API function. It can create a .bmp or .png file in any of the 40 versions and four error correction levels, based on the amount and datatype of the information to be encoded.

   https://github.com/perevoznyk/quricol/releases/tag/v2.1

I've created an example app that uses the Quricol dll to create a QR Code graphics file and display it in a DataWindow. If you or anyone else is interested in examining it, reply and I'll make it available.

John

Comment
  1. Sivaprakash BKR
  2. Thursday, 12 May 2022 05:23 AM UTC
John,

Till it's supported by PB (planned in v2022), I think it will be useful for all to have this. I'm really interested in testing out other options. Can you provide your code?

Thanks
  1. Helpful
  1. Olan Knight
  2. Thursday, 12 May 2022 13:41 PM UTC
Many thanks, John! Yes, I will check this out this evening! Thank you VERY MUCH for your time and effort!



I tried to work with the code from Bruce Armstrong, but it requiires knowledge of SnapDevelop, and I am a complete noob with SnapDevelop. I got to where I was trying to create the object to put into a COM wrapper, but it just giving me errors and I had no idea how to correct them. :(
  1. Helpful
  1. John Fauss
  2. Thursday, 12 May 2022 14:00 PM UTC
This evening I will post the sample app to my Google Drive and provide a link to it here, so check back. In the meantime, download the Quricol binaries (the 32-bit and 64-bit dll's) from the GitHub link I provided above. as the example app I've created requires these dll's.
  1. Helpful
There are no comments made yet.
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Monday, 2 May 2022 07:16 AM UTC
  2. PowerBuilder
  3. # 3

Hello,

DISCLAIMER:  The attached software is developed using Windev 22.    As with any other software, this software is also comes with no warranty / guarantee to work as intended.  Use it at your own risk. 

One can use this software by calling the exe file from PB application (Topwizprogeramming's Run and Wait program is very useful to call this exe), to
1.   Print Barcode
2    To capture images via attached Webcam

How to Print Barocde.   
Call the exe with the following parameters.
Elifa4Capture.exe ls_command ls_outputfile ls_value_to_barocde ls_barcode_type
ls_command -> BARCODE ( hardcoded to make the program to print barcode )
ls_outputfile -> Barcode will be stored as an image in the output file mentioned.  Include full path name.
ls_value_to_barcode -> This value will be converted to barcode
ls_barcode_type ->  Allowed values (QRCODE / EAN 128 / EAN 13 / CODE 39 / CODE 93 / CODE 128 / CODE 11 /BAR CODE / PDF417 / DATAMATRIX /  Aztec)

How to Capture Images
Call the exe with the following parameters.
Elifa4Capture.exe ls_command ls_outputfile
ls_command -> CAPTURE
ls_outputfile -> image will be saved in this file name (only jpg is supported as of now)

Hope this tool will be useful.
Let me know about your thoughts.

Happiness Always
BKR Sivaprakash

 

Attachments (1)
Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Sunday, 1 May 2022 15:37 PM UTC
  2. PowerBuilder
  3. # 4
Comment
  1. Olan Knight
  2. Sunday, 1 May 2022 15:42 PM UTC
Perfect! Thank you, Miguel. I'll check them out and report back!



Thanks,

Olan
  1. Helpful
  1. Miguel Leeuwe
  2. Sunday, 1 May 2022 15:45 PM UTC
YW
  1. Helpful
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Sunday, 1 May 2022 04:42 AM UTC
  2. PowerBuilder
  3. # 5

Hi, Olan -

Today's Trivia Tidbit: "QR" stands for "Quick Response".

To build upon Armeen's quick response to your question, have you looked in CodeXchange? Here's a link to a submission from Bruce Armstrong that uses PB 2019 R3:

   https://community.appeon.com/index.php/codeexchange/powerbuilder/284-qr-code-generator

I am somewhat reluctant to suggest links to Wikipedia, but their article on QR Codes is pretty robust. https://en.wikipedia.org/wiki/QR_code and there are many other tutorials on the subject of QR Codes to be found on the web.

Finally, I know this doesn't address your immediate need, but QR Code generation is on the product roadmap for PB 2022 (I'm surprised Armeen didn't mention this). I do not know if it will be included in the initial release or in a later release.

   https://www.appeon.com/developers/roadmap#upcoming

Comment
  1. Armeen Mazda @Appeon
  2. Sunday, 1 May 2022 14:40 PM UTC
Thanks John! I forgot we already had example in CodeXchange and that it was on our roadmap.
  1. Helpful
  1. Olan Knight
  2. Sunday, 1 May 2022 15:46 PM UTC
Thank you, John!

  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Sunday, 1 May 2022 03:35 AM UTC
  2. PowerBuilder
  3. # 6

Don’t know if there is a better way, but one idea is to get a free open source library and integrate into your app.  There are many such generators for .NET.  Here is just one example: https://www.nuget.org/packages/QRCoder/ 

PB 2019 R3 and newer has a fairly robust .NET DLL importer.  For older PB versions you could creat a COM wrapper.

Comment
  1. Olan Knight
  2. Sunday, 1 May 2022 15:46 PM UTC
Thank you, Armeen!

  1. Helpful
  1. Armeen Mazda @Appeon
  2. Sunday, 1 May 2022 15:50 PM UTC
Very welcome!
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.