Re: scanning data into an oracle form

[Quoted] Although it's not quite the same thing, we use barcode readers to read data into a [Quoted] form from barcoded data. The reader connects between the keyboard and input port [Quoted] and contains firmware to convert the barcode data into ascii data and displays it [Quoted] where ever your cursor is active, be it a word processor or a form field. It will [Quoted] even throw in a carriage return for you so it becomes a simple matter to scan data [Quoted] into for example, a display field and, in a new_item_instance trigger, to parse out [Quoted] the data into separate text fields. Seems to me that OCR readers should work the same way.

Bob

Steffen Stellwag wrote:

> beichman_at_my-dejanews.com wrote:
> >
> > I have an "over the counter" cash remittance system where a PC attached
> > scanner is used to read information on an OCR line at the bottom of a payment
> > stub. Or, if you will, a person walks up to a cashier with a bill to pay, the
> > cashier takes the payment coupon from the bill and runs it through a device
> > which can read the OCR font line and get the account number and payment
> > amount in ASCII text. In the current system (a dumb terminal application) the
> > ascii text gets "typed" on the screen automatically. Now we are moving to a
> > Developer 2000 based form developed by a third party. I need to get a
> > scanner that reads the OCR line to take the resulting string and fill three
> > separate fields on the Oracle GUI form: a 9 digit customer number, a 7 digit
> > location number and an amount due. Any pointers would be most welcome.
> > regards, johnb
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
> Hi,
>
> The trick is you´'ve to tell forms, that now the incoming data is not
> from the keybord rather from scanner.
>
> 1: Enforce your scanner to send first a control sequence for example
> control S that fires a certain trigger.
>
> 2. define a corresponding KEY_stoke for this sequence in ORACLE
> Terminal. CTRL_S <-> F12
>
> 3. Define a userdefined KEY_trigger for F12 at forms level.
>
> 4. define a block SCAN_FIELDS with 3 fiels S1,S2,S3 on a canvas
> SCAN_CANVAS...
>
> 5 . Trigger text in KEY_F12
> begin
> go_block SCAN_FIELDS;
> end;
>
> I dis this 4 years ago , and therefor I dont know whether its all ok.
>
> Try it .
>
> Regards
Received on Tue Sep 22 1998 - 13:50:54 CEST