Re: scanning data into an oracle form

Gentlemen:

thank you both for your help; I'll give it a try and letcha know what happens. johnb
In article <36078F1E.E2908D9_at_census.gov>,   rsauer_at_census.gov wrote:
> Although it's not quite the same thing, we use barcode readers to read data
into a
> form from barcoded data. The reader connects between the keyboard and input
port
> and contains firmware to convert the barcode data into ascii data and
displays it
> where ever your cursor is active, be it a word processor or a form field. It
will
> even throw in a carriage return for you so it becomes a simple matter to scan
data
> into for example, a display field and, in a new_item_instance trigger, to
parse out
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 23 1998 - 22:32:32 CEST