Re: scanning data into an oracle form

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...

    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 - 11:54:34 CEST