Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved ASCII control character in datawindow column

  1. How-to
0
Votes
Undo
  1. André Monz
    André Monz
  2. PowerBuilder
  3. Wednesday, 21 April 2021 05:00 AM UTC

Hi,

we are using a datawindow with external data source to receive barcodes from BC-Readers.
The Barcodes are trades item numbers, formerly EAN, now GTIN.
The column 'ean' is defined as string.
This works pretty good since years.
Now we have to handle barcodes with a ASCII control character GS (ASCII 29, Hex 1D).
It seems powerbuilder supresses such control characters.
I can't find them eg. in the data argument of the editchanged event.
Is there a way to catch them in a datawindow control?
Thank you.

André

 

Tried to pass a structure with arrays to a func...
Datawindow searching using single line edit
Accepted Answer
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Thursday, 22 April 2021 12:29 PM UTC
  2. PowerBuilder
  3. # Permalink

GS ist the group separator in datamatrix label. Maybe you can do some changes in the scanner driver to get the data in an encoded was (e.g. hex encoded)

https://www.gs1.org/docs/barcodes/GS1_DataMatrix_Guideline.pdf#page=24

 

Comment
André Monz
  1. André Monz
  2. Monday, 26 April 2021 11:49 AM UTC
After considering different ways, we will go that way.

The Scanners we officially suggest have a build in replace function.

This function we will use to replace control characters with somewhat that our DWs accept.

  1. Helpful
There are no comments made yet.
Responses (3)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 22 April 2021 15:02 PM UTC
  2. PowerBuilder
  3. # 1

I played with barcode scanners in the distant past.

My biggest recollection is that ALL of the data read from the scanner comes to the DW as a string, and you MUST accept that data as a string, which means putting it into a SLE, MLE, or a DW column defined as a string.

Once the data has been received, you parse it for anything you need - for example, control characters - and then put the appropriate segments where you wish, then continue processing.

 

Later -

Olan

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 21 April 2021 16:46 PM UTC
  2. PowerBuilder
  3. # 2

Hi,

Maybe it will help if you provide more information.

How do you get the data into your external datawindow?

regards

Comment
André Monz
  1. André Monz
  2. Thursday, 22 April 2021 08:13 AM UTC
Hi Miguel,



our customers sell retail medical merchandise.

These products have a datamatix label on their packaging.

The labels are scanned with a USB-Scanner like the Honeywell Voyager 1400g.

The scanner stores the data in the keyboard buffer.

In our POS-Software the EAN column (now a Column named UDI up to 255 characters) has the focus an

receive the data.

At the moment it seems we have to replace the DW with a Single-/Multilineedit-Control,they

don't supress the control characters.

But we would like to avoid that, and continue to use our datawindows.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 22 April 2021 08:20 AM UTC
Ah, okay.

so something connected to the pc will send data to the external datawindow and the editchanged / itemchanged events are being fired, what about the ItemError event?

  1. Helpful
André Monz
  1. André Monz
  2. Thursday, 22 April 2021 12:10 PM UTC
Just tried, itemerror is not fired.
  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.