Re: Forms 4.5: <Enter> key Trigger

In article <5jo69k$beg$1_at_power42t.hkbu.edu.hk>, YyWong <yywong_at_math.hkbu.edu.hk> wrote:
>I am now writing a form to query a barcode number!
>Normally, the barcode reader will scan a barcode and input the
>associated number into a [Enter-Query] field with a carriage-
>return <Enter key>.
>
>But, how can I fire a trigger to execute-query when the <Enter Key>
>is detected?
>I have tried to use the trigger <Key-Enter> which I think would
>be the solution to the item. But, it doesn't work! Before doing this
>I checked that the "Fire on Enter Query Mode" property is set to TRUE
>
>Can anyone give me some suggestion? Or do I make some mistake on
>the trigger <Key-Enter>?
>In fact, I have tried to modify the <Key-F8> trigger to perform a
>"Exit_Form" function! However, it seems that the runform ignore it
>and fire the original "Execute_Query" command!???

The Key-Enter trigger only works with block-mode terminals, The only one I know of is ibm-3270. It is executed when the user finishes keying all the data into all the fields, then pressing the numeric keypad enter key. It doesn't work on normal Oracle Forms clients, such as those running under Windows.

To query your database based on the numeric entry followed by a carriage-return, set up a hidden navigable item following the bar-code item. Then, the carriage-return following the bar code number will cause the cursor to move to the hidden item. In this item's when-new-item-instance trigger, set the block's default-where clause based on the bar-code number, and then do an execute_query.

HTH,
Steve Cosner Received on Mon Apr 28 1997 - 00:00:00 CEST