1. hadi raad
  2. PowerBuilder
  3. Thursday, 01 November 2018

Dear Appeon Team  

 
I am trying to add Q-R code in Data window (report ) that has been designed in power builder 10.5 version
and I can’t find the correct way to add it .
is there any way to add Q-R code as component in report

please advise   

Attachments (1)
Juan Alejandro Lam López Accepted Answer Pending Moderation
0
Votes
Undo

I sent you an example of code in Appeon Powerbuilder 17 R3, you can use it and replicate it in any version.

Attachments (1)
Comment
I tried your tool.... following errors.



Could only register UnityEngine.dll

While trying to register itextsharp.dll [ Manually ], Warning: RA0000: No types were registered error is coming

zen.barcode.core.dll is not found

facturador.dll - says it's not a valid .net assembly.
  1. Sivaprakash BKR
  2. Wednesday, 14 November 2018
There are no comments made yet.
  1. Tuesday, 13 November 2018
  2. PowerBuilder
  3. # 1
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

If the DataWindow object is a text control called t_qrcode:

dw_1.object.t_qrcode.text = ls_qrcode

 

 

Comment
There are no comments made yet.
  1. Monday, 12 November 2018
  2. PowerBuilder
  3. # 2
hadi raad Accepted Answer Pending Moderation
0
Votes
Undo

Dear Brad 
i have already installed the font and the encoder that you provide in the post 
i appropriate the code in the example you mention
but i really need to know where to use the code because in the data windows that i work on i cant edit the back code of element as text control 
please if you can provide me with the pb library of the example you made 

so much thanks

Comment
Hadi,

The code we use is for Barcode 128, and it's an embedded part of a report system.



We created a dummy column in the select statement from the database, and at runtime, we populated that field with the barcode data so it can be used on each individual row of the report. The basic logic is that after the retrieve, we loop through each row and compute the barcode value for the dummy field from other field values (we're encoding several different types of reference numbers), then use setitem to plug the value into the column. The report can then be viewed/printed and the appropriate barcode shows for each row.
  1. Brad Mettee
  2. Sunday, 11 November 2018
There are no comments made yet.
  1. Sunday, 11 November 2018
  2. PowerBuilder
  3. # 3
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

On a very slightly similar topic, I have a dll & sample of how to print the US Postal Service address barcodes.

http://www.topwizprogramming.com/freecode_usps4cb.html

 

Comment
There are no comments made yet.
  1. Wednesday, 7 November 2018
  2. PowerBuilder
  3. # 4
Brad Mettee Accepted Answer Pending Moderation
0
Votes
Undo

I created a full new reply so I could do a proper code sample.

We've been using IDAutomation's universal barcode generator for 10+ years now. They have a version for QR codes as well.

ID Automation QR Code Font

I haven't looked at pricing recently, there are several tiers to choose from

Once installed (font and data encoder), here's sample code to generate the text the font uses to produce a QRCode. Text field (static text or db column) will need to be tall enough to fit the entire QRCode.

 

oleobject ole_qrcodegen
ole_qrcodegen = create oleobject
long ll_status

ll_status = ole_qrcodegen.ConnectToNewObject("IDAuto.QRCode")
if ll_status = 0 then
    string ls_result, ls_str2encode
    ls_result = space(8192)
    int ProcessTilde, EncodingMode = 0, ECL = 0, Ver = 0
    ls_str2encode = "now is the time"
    ole_qrcodegen.FontEncode(ls_str2encode, ProcessTilde, EncodingMode, ECL, Ver, ref ls_result)
    ole_qrcodegen.disconnectobject()
end if

 

 

The text in ls_result can be put into a text field in a DW to show a QR Code, providing it's font is set properly. 

Comment
There are no comments made yet.
  1. Tuesday, 6 November 2018
  2. PowerBuilder
  3. # 5
hadi raad Accepted Answer Pending Moderation
0
Votes
Undo

Dear Roland 

Thanks for your reply , it is not really what i am looking for .

when i use q-code as font it is only convert the type of font 

i need to use Q-R code as encoding way so i can use the mobile camera to decode the Q-RCode Square 

 

thanks 

Comment
Hadi,

What you are saying doesn't quite make sense. You either need to generate a QR code for display/printing, or you need to scan one and decode it for processing. There's a huge difference between the two.



To encode a QR code, you'll need an appropriate font, as indicated by Roland, and an encoder dll or activex control to turn your data string into the right characters for the font to make up the code itself. After you encode your data, you place it into a text/field object on a datawindow that's set to use the QR code font.



To decode a QR code, you'll need a DLL or ActiveX object that can access the scanning device (a hand held camera based scanner, or a built in camera).



If you describe what you actually need, we may be able to point you in a better direction.



  1. Brad Mettee
  2. Sunday, 4 November 2018
Dear Brad

I am trying to generate and encode QR code in my data windows report in power builder

i tried the QR font that exists the internet and it doesn't work ...

and i used the Dll encoder (Qrmaker.OCX) and register it but when i try to insert the QR-maker control it show that message ( insertion of ole object failed license file required )

and i found anther way to do that but in window (exe ) in power builder and i need to use it in data window ( report)

if you had the right way to do what you mention in your second section of your comment

please advice



so much thanks for you
  1. hadi raad
  2. Tuesday, 6 November 2018
There are no comments made yet.
  1. Sunday, 4 November 2018
  2. PowerBuilder
  3. # 6
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

You should be able to do it using a special QR code font.

Comment
There are no comments made yet.
  1. Thursday, 1 November 2018
  2. PowerBuilder
  3. # 7
  • Page :
  • 1


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