How to query a Sql database using a parsed section of scanned QR code

Brent Fulks

• May 11, 2017 01:50

Would like to develop the following:

1. User is prompted to scan a QR code (which consists of a work order number, purchase order number, item number, and quantity)

2. Template parses scanned input, and populates individual text boxes on label (this is done)

3. Template then queries a SQL database to return the item description, using the item number previously parsed in step 1

In other words, is it possible to use just a portion of scanned text as the query criteria?

0

• 

  Peter Bartsch

  ★ BarTender Hero ★

  • March 19, 2019 20:17

  Was this ever solved.  I have the same type of question.

  How do I parse out information scanned in from a QR code?

  Thanks,

  Peter

  0
• 

  Peter Thane

  ★ BarTender Hero ★

  • March 20, 2019 20:13

  Hi Peter,

  You will need to do something similar to the reply I just posted up to your other query

  https://support.seagullscientific.com/hc/en-us/community/posts/360028789754-Parsing-Scanned-Data?page=1#community_comment_360004495454

  In the Database Filter and Query Prompt you will need to use VB script to find the semicolon deliminator and then just retain the data to the left of it as in the 1st VB script routine.

  Pete

  0

Please sign in to leave a comment.