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

Brent Fulks

• 2017年05月11日 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 ★

  • 2019年03月19日 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 ★

  • 2019年03月20日 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

請登入寫評論。