How to Read Bar Codes in Oracle
Forms
How to read Bar Codes written on the product? How to read bar codes in oracle forms for information of the product? --- Using Symbol Technologies bar code readers (or another manufacturer) you can enter bar code info to Oracle Database. The bar code reader can be installed to keyboard connector. As a user interface you can use Developer 2000/Forms, Pro*C etc. You have may options for end user interface. Then you can print bar code data
from Oracle Reports or from Pro*C if you install bar code fonts to your
operating system (W'95. 2000, XP whatever). Then change the bar code data
in Reports to bar code font.
Here are two possible scenarios: 1. You need to walk around a large area, scan in a number of items and then dump this information into a database. For this application it is recommended you get a scanner
with memory so that the items are stored within the scanner . This information
can then be dumped into an ascii flat file loaded directly into the
2. Items are brought to the scanner and scanned in. A description of each item is displayed on the screen and the user is given the option to delete, modify, or commit the data to the database. This is the type of scanning operation that most of us are familiar with as this is the typical supermarket check out scanning. The easiest way to implement this within Oracle Developer Forms is to purchase a scanner that will fit "between'" the computer and the keyboard and allow input from both devices. Say, for example you are just going to scan in codes and you want to validate the code (see it's translation )before you enter the data into the db. One simple approach is to create a form with one block and two items: SCANNED_ITEM - A form base table table item corresponding to an inventory table which will contain your scanned codes TRANSLATE - A description of the item in a db table called LOOK_UP_ITEM which contains valid codes and descriptions. The table structure for table LOOK_UP_ITEM could be as follows; NAME CONTENTS
Then create a key-next-item trigger on SCANNED_ITEM with code similar to the following: CODE DECLARE
In order to cause the key-next-item to execute you will need to ensure the bar code reader sends a TAB key sequence at the end of each scan so that the key-next-item trigger will fire.
Have a Oracle Question
Oracle Books
Oracle Application
Oracle Home
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|