This discussion is archived
5 Replies Latest reply: Jan 12, 2013 11:25 PM by user346369 RSS

Function Keys in 11g.

ocpdev Newbie
Currently Being Moderated
Hi All,

I was using following function keys in Form 6i;

F7 for Enter Query.
F8 for Execute Query.
F9 for LOV.

But these function keys are not working in 11gr2 for the same functionality.

Pl guide me how can we do this in 11gr2 forms ?

Thanks.
  • 1. Re: Function Keys in 11g.
    CraigB Guru
    Currently Being Moderated
    This is a well documented change between Forms 6i and Forms 9i and higher. When running your Forms 11g application press Ctrl + K to display the list of key strokes. Enter Query is now F11; Execute Query is now Ctrl + F11 and List LOV is now Ctrl + L.

    Hope this helps,
    Craig...
  • 2. Re: Function Keys in 11g.
    user346369 Expert
    Currently Being Moderated
    CraigB wrote:
    This is a well documented change between Forms 6i and Forms 9i and higher. When running your Forms 11g application press Ctrl + K to display the list of key strokes. Enter Query is now F11; Execute Query is now Ctrl + F11 and List LOV is now Ctrl + L.
    Or find your installation of the function key resource file, fmrweb.res
    (mine resides in D:\DevSuiteHome_1\forms )

    There should also be a file named fmrpcweb.res. Rename your old fmrweb.res to something else, and copy fmrpcweb.res as fmrweb.res.

    Since our users started with Client/Server forms, when they went to Web Forms, they were given the same function key definitions. Here's a copy of what we use:

    <pre># fmrweb.res file for Web Forms 10.
    #
    # FMRWEB.RES is the key definition file for webforms. The syntax is:
    #
    # JFN : JMN : URKS : FFN : URFD (whitespace ignored)
    #
    # JFN = Java function number
    # JMN = Java modifiers number
    # URKS = User-readable key sequence (double-quoted)
    # FFN = Forms function number
    # URFD = User-readable function description (double-quoted)
    #
    # JAVA FUNCTION NUMBER
    # 33 = PageUp
    # 34 = PageDown
    # 35 = End
    # 36 = Home
    # 37 = LeftArrow
    # 38 = UpArrow
    # 39 = RightArrow
    # 40 = DownArrow
    # 65 - 90 = Ctrl+A thru Ctrl+Z (These will always have the control
    # modifier explicitly included, as well as any other
    # modifiers that might be used.)
    # 112 - 123 = F1 thru F12
    # 9 = Tab (Ctrl+I, without the control modifier)
    # 10 = Return (Ctrl+J, without the control modifier)
    #
    # JAVA MODIFIERS NUMBER
    # Equal to the sum of the values for the modifier keys:
    # 0 = None
    # 1 = Shift
    # 2 = Control
    # 4 = Meta
    # 8 = Alt
    #
    # FORMS FUNCTION NUMBER (Ffn)
    # The Forms function numbers match the function numbers found in a
    # typical Forms key binding file.
    #
    # USER-READABLE STRINGS (URFD)
    # The double-quoted strings appear when users click [Show Keys], and
    # are used for this purpose only. These strings can be translated as
    # needed. Note that the strings do not affect what actually happens
    # when end users press a particular key sequence.
    #
    # If the function key defined in the form has text defined in the
    # 'Keyboard Help' Text property, THAT text displays for the function key
    # instead of the text given in the URFD column here.
    #
    #
    #Jfn :Jmn: URKS :Ffn : URFD
    # : : (User-readable : : (User-readable
    # : : Key-sequence ) : : function description)
    #-- --- - - - - - - - - - --- - - - - - - - - - - - -
    118 : 1 : "Shift F7" : 74 : "Clear Form"
    121 : 0 : "F10" : 36 : "Commit"
    117 : 0 : "F6" : 65 : "Create Record"
    # #--Alt+Home works, but leaves the Action (first
    # #--pull-down menu item) highlighted. Press Esc or
    36 : 8 :"Alt Home, then Alt":82: "Cursor to Home"#-- Alt again to clear highlight.
    123 : 0 : "F12" : 82 : "Cursor to Home"
    10 : 1 : "Shift Enter" : 82 : "Cursor to Home"
    117 : 1 : "Shift F6" : 63 : "Delete Record"
    119 : 0 : "F8" : 77 : "Execute Query"
    120 : 0 : "F9" : 29 : "List of Values"
    9 : 0 : "Tab" : 1 : "Next Field"
    40 : 0 : "Down-Arrow" : 7 : "Next Record"
    9 : 1 : "Shift Tab" : 2 : "Previous Field"
    38 : 0 : "Up-Arrow" : 6 : "Previous Record"
    112 : 0 : "F1" : 35 : "Show Keys"
    #
    # Space (actually hex A0) in first position of URFD causes these key
    # descriptions to display below the keys above.
    #
    116 : 1 : "Shift F5" : 69 : " Clear Block"
    116 : 2 : "Ctrl F5" : 3 : " Clear Field"
    34 : 1 : "Shift+PageDown" : 71 : " Next Block"
    33 : 1 : "Shift+PageUp" : 72 : " Previous Block"
    113 : 1 : "Shift F2" : 80 : " Count Query Hits"
    112 : 1 : "Shift F1" : 78 : " Display Error"
    114 : 0 : "F3" : 73 : " Duplicate Item"
    115 : 0 : "F4" : 64 : " Duplicate Record"
    69 : 2 : "Ctrl E" : 22 : " Edit Field"
    122 : 0 : "F11" : 75 : " Enter " # Causes validation, w/o cursor move
    118 : 0 : "F7" : 76 : " Enter Query"
    81 : 2 : "Ctrl Q" : 32 : " Exit Form"
    34 : 0 : "Page Down" : 66 : " Next Set of Records"
    119 : 1 : "Shift F8" : 79 : " Print"
    80 : 2 : "Ctrl P" : 79 : " Print"
    10 : 0 : "Enter/Return key": 27: " Enter/Next Field"
    33 : 0 : "Page Up" : 12 : " Scroll Up"
    116 : 0 : "F5" : 87 : " F5 Key for special uses"
    #
    # Function keys (Ffn 82-91) do not show up in the Key Help display
    # unless the corresponding key trigger exists in the form.
    #
    112 : 3 : "Shift Ctrl F1" : 83 : " Function 1"
    113 : 0 : "F2" : 84 : " Function 2"
    113 : 11: "Ctrl Alt Shift F2":95: " List Tab Pages" #<-REQUIRED, or F2 cant be assigned
    114 : 3 : "Shift Ctrl F3" : 85 : " Function 3"
    115 : 3 : "Shift Ctrl F4" : 86 : " Function 4"
    117 : 3 : "Shift Ctrl F6" : 88 : " Function 6"
    118 : 3 : "Shift Ctrl F7" : 89 : " Function 7"
    119 : 3 : "Shift Ctrl F8" : 90 : " Function 8"
    120 : 3 : "Shift Ctrl F9" : 91 : " Function 9"
    </pre>
  • 3. Re: Function Keys in 11g.
    ocpdev Newbie
    Currently Being Moderated
    Thanks Craig !

    It helped me completely.

    Tell me also for F3 (which is meant for copy previous record into current one).

    Regards.
  • 4. Re: Function Keys in 11g.
    ocpdev Newbie
    Currently Being Moderated
    Thanks Steve !

    It helped me.
  • 5. Re: Function Keys in 11g.
    user346369 Expert
    Currently Being Moderated
    ocpdev wrote:
    Tell me also for F3 (which is meant for copy previous record into current one).
    ocpdev,
    You can find the translations in the fmrweb.res file.

    Below is the Web Forms fmrweb.res file, showing the values CraigB gave you above, and also shows:

    shift F6 is Duplicate Record, (Client/Server Forms was F4)
    shift F5 is Duplicate Field, (Client/Server Forms was F3).

    As I wrote above, you can change what the function keys do, by editing the file (or renaming it).

    <pre>9 : 0 : "Tab" : 1 : "Next Field"
    9 : 1 : "Shift+Tab" : 2 : "Previous Field"
    116 : 0 : "F5" : 3 : "Clear Field"
    38 : 0 : "Up" : 6 : "Up"
    40 : 0 : "Down" : 7 : "Down"
    33 : 0 : "PageUp" : 12 : "Scroll Up"
    34 : 0 : "PageDown" : 13 : "Scroll Down"
    69 : 2 : "Ctrl+E" : 22 : "Edit"
    10 : 0 : "Return" : 27 : "Return"
    76 : 2 : "Ctrl+L" : 29 : "List of Values"
    115 : 0 : "F4" : 32 : "Exit"
    75 : 2 : "Ctrl+K" : 35 : "Show Keys"
    83 : 2 : "Ctrl+S" : 36 : "Commit"
    118 : 1 : "Shift+F7" : 61 : "Next Primary Key"
    117 : 0 : "F6" : 62 : "Clear Record"
    38 : 2 : "Ctrl+Up" : 63 : "Delete Record"
    117 : 1 : "Shift+F6" : 64 : "Duplicate Record"
    40 : 2 : "Ctrl+Down" : 65 : "Insert Record"
    119 : 1 : "Shift+F8" : 66 : "Next Set of Records"
    1005 : 0 : "Down" : 67 : "Next Record"
    1004 : 0 : "Up" : 68 : "Previous Record"
    118 : 0 : "F7" : 69 : "Clear Block"
    66 : 2 : "Ctrl+B" : 70 : "Block Menu"
    34 : 1 : "Shift+PageDown" : 71 : "Next Block"
    33 : 1 : "Shift+PageUp" : 72 : "Previous Block"
    116 : 1 : "Shift+F5" : 73 : "Duplicate Field"
    119 : 0 : "F8" : 74 : "Clear Form"
    122 : 0 : "F11" : 76 : "Enter Query"
    122 : 2 : "Ctrl+F11" : 77 : "Execute Query"
    69 : 3 : "Shift+Ctrl+E" : 78 : "Display Error"
    80 : 2 : "Ctrl+P" : 79 : "Print"
    123 : 0 : "F12" : 80 : "Count Query"
    85 : 2 : "Ctrl+U" : 81 : "Update Record"
    121 : 3 : "Shift+Ctrl+F10" : 82 : "Function 0"
    112 : 3 : "Shift+Ctrl+F1" : 83 : "Function 1"
    113 : 3 : "Shift+Ctrl+F2" : 84 : "Function 2"
    114 : 3 : "Shift+Ctrl+F3" : 85 : "Function 3"
    115 : 3 : "Shift+Ctrl+F4" : 86 : "Function 4"
    116 : 3 : "Shift+Ctrl+F5" : 87 : "Function 5"
    117 : 3 : "Shift+Ctrl+F6" : 88 : "Function 6"
    118 : 3 : "Shift+Ctrl+F7" : 89 : "Function 7"
    119 : 3 : "Shift+Ctrl+F8" : 90 : "Function 8"
    120 : 3 : "Shift+Ctrl+F9" : 91 : "Function 9"
    113 : 0 : "F2" : 95 : "List Tab Pages"
    72 : 2 : "Ctrl+H" : 30 : "Help"</pre>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points