Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

use of F8 &F10 keys in keyboard to execute query & save a form

980086Mar 29 2013 — edited Apr 1 2013
I have created a screen.Here I can save by pressing ctl+S(written a key-commit trigger) or save button I have placed.
Now user want F10 key to save & F8 key to execute query.
How Can I do that?Which trigger should I write with code...
I am using oracle 10g and oracle developer suite 10g.
I have fmrweb.res as follow :-


9 : 0 : "Tab" : 1 : "Next Field"
9 : 2 : "Ctrl+Tab" : 1 : "Next Field"
9 : 1 : "Shift+Tab" : 2 : "Previous Field"
9 : 3 : "Shift+Ctrl+Tab" : 2 : "Previous Field"
85 : 2 : "Ctrl+U" : 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 : "Enter" : 27 : "Return"
120 : 0 : "F9" : 29 : "List of Values"
76 : 2 : "Ctrl+L" : 29 : "List of Values"
81 : 2 : "Ctrl+Q" : 32 : "Exit"
75 : 2 : "Ctrl+K" : 35 : "Show Keys"
112 : 2 : "Ctrl+F1" : 35 : "Show Keys"
83 : 2 : "Ctrl+S" : 36 : "Commit"
121 : 2 : "F10" : 36 : "Commit"
114 : 1 : "Shift+F3" : 61 : "Next Primary Key"
115 : 1 : "Shift+F4" : 62 : "Clear Record"
117 : 1 : "Shift+F6" : 63 : "Delete Record"
115 : 0 : "F4" : 64 : "Duplicate Record"
117 : 0 : "F6" : 65 : "Insert Record"
119 : 1 : "Shift+F8" : 66 : "Next Set of Records"
1005 : 0 : "Down" : 67 : "Next Record"
1004 : 0 : "Up" : 68 : "Previous Record"
40 : 1 : "Shift+Down" : 67 : "Next Record"
38 : 1 : "Shift+Up" : 68 : "Previous Record"
116 : 1 : "Shift+F5" : 69 : "Clear Block"
116 : 0 : "F5" : 70 : "Block Menu"
34 : 1 : "Shift+PageDown" : 71 : "Next Block"
33 : 1 : "Shift+PageUp" : 72 : "Previous Block"
34 : 2 : "Ctrl+PageDown" : 71 : "Next Block"
33 : 2 : "Ctrl+PageUp" : 72 : "Previous Block"
114 : 0 : "F3" : 73 : "Duplicate Field"
118 : 1 : "Shift+F7" : 74 : "Clear Form"
118 : 0 : "F7" : 76 : "Enter Query"
119 : 0 : "F8" : 77 : "Execute Query"
122 : 0 : "F11" : 76 : "Enter Query"
122 : 2 : "Ctrl+F11" : 77 : "Execute Query"
112 : 1 : "Shift+F1" : 78 : "Display Error"
80 : 2 : "Ctrl+P" : 79 : "Print"
113 : 1 : "Shift+F2" : 80 : "Count Query"
123 : 0 : "F12" : 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"
112 : 0 : "F1" : 30 : "Help"

please suggest...
This post has been answered by GregorM on Apr 1 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2013
Added on Mar 29 2013
11 comments
3,625 views