OraFAQ Forum: Forms » master-detail form

Home » Developer & Programmer » Forms » master-detail form (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

master-detail form [message #575176]

Sun, 20 January 2013 23:31

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

hi sir

i have a master-detail form.before filling up all the item in master cursor
should not go to details,if user clicks in detail he should get a message.

when i am pressing ENTER to navigate from one item to another is asking
'do u want to save the changes'.how to control this message and when pressed
enter cursor should go to next item.please provide solution for this.

thanks in advance.
regards

Report message to a moderator

Re: master-detail form [message #575180 is a reply to message #575176]

Mon, 21 January 2013 01:01

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

When you press <ENTER>, KEY-NEXT-ITEM trigger fires (if you have it). What does it do? Are there any other triggers that fire upon that event?

Report message to a moderator

Re: master-detail form [message #575182 is a reply to message #575176]

Mon, 21 January 2013 01:46

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

thanks for your reply ...

no sir i dont have key next item trigger in my form.
just when i press enter anywhere in the form its aksing
DO U WANT TO SAVE CHANGES U MADE..i dont want this message
to appear instead it shud go to next item.

regards

Report message to a moderator

Re: master-detail form [message #575183 is a reply to message #575182]

Mon, 21 January 2013 02:06

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, something causes that message. Run the form in debug mode and see what's going on.

Report message to a moderator

Re: master-detail form [message #575184 is a reply to message #575183]

Mon, 21 January 2013 02:08

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

how to run a form in debug mode..? please...

i think when i am pressing enter key it is assuming EXIT_FORM;

help
regards

[Updated on: Mon, 21 January 2013 02:11]

Report message to a moderator

Re: master-detail form [message #575185 is a reply to message #575184]

Mon, 21 January 2013 02:20

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I suppose you use Forms 10g, don't you?

Open Forms Help and read about debug mode in there. Shortly: if you don't have it already, create a WHEN-NEW-FORM-INSTANCE trigger and put

null;

in it. Click on the left margin and set the breakpoint. In order to run a form, there are two green icons - one of them runs the form "normally", while the other one runs it in debug mode.

Report message to a moderator

Re: master-detail form [message #575186 is a reply to message #575185]

Mon, 21 January 2013 02:36

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

i run the form in debug mode nothing happen.

when i run the same form locally and press ENTER cursor
is moving to next item but when i running it remotely from
server its showing that message.

thanks
regards

Report message to a moderator

Re: master-detail form [message #575187 is a reply to message #575186]

Mon, 21 January 2013 02:40

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is <ENTER> key mapped to something different on IAS? If so, check it with administrator. Maybe you'd want to restore its original settings.

Report message to a moderator

Re: master-detail form [message #575188 is a reply to message #575187]

Mon, 21 January 2013 02:44

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

how to check it...i can check please guide me..

Report message to a moderator

Re: master-detail form [message #575189 is a reply to message #575188]

Mon, 21 January 2013 02:46

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Key mappings are in FMRWEB.RES file (or, if you set another .RES file, you'd probably know its name).

Report message to a moderator

Re: master-detail form [message #575190 is a reply to message #575189]

Mon, 21 January 2013 02:49

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

this is the file...what should i change in this...

# 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
# The Forms function numbers match the function numbers found in a
# typical Forms key binding file.
#
# USER-READABLE STRINGS
# 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.
#
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" : 77 : "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" : 27 : "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"

Report message to a moderator

Re: master-detail form [message #575191 is a reply to message #575190]

Mon, 21 January 2013 02:56

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is it your own file (on your PC), or the one located on IAS? Because, there's nothing here that would suggest that <ENTER> (i.e. "return") is mapped to something different.

Report message to a moderator

Re: master-detail form [message #575192 is a reply to message #575191]

Mon, 21 January 2013 02:59

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

it is a file located on IAS.
one more file i found with same name..slightly different

# 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
# The Forms function numbers match the function numbers found in a
# typical Forms key binding file.
#
# USER-READABLE STRINGS
# 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.
#
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"

Report message to a moderator

Re: master-detail form [message #575193 is a reply to message #575192]

Mon, 21 January 2013 03:48

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

thanks a lot for bearing with me for so long...

i solved the problem

i replace
10 : 0 : "Return" : 77 : "Return" with
10 : 0 : "Return" : 27 : "Return"

thank god....its solved now...

thanks little foot.....thanks and really appreciate your help to all..
regards

Report message to a moderator

Re: master-detail form [message #575194 is a reply to message #575193]

Mon, 21 January 2013 03:54

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm glad you solved the problem.

Report message to a moderator

Re: master-detail form [message #575199 is a reply to message #575194]

Mon, 21 January 2013 04:29

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

thank you very much but you are the one who showed the way...!!! Smile

Smile

Report message to a moderator

Previous Topic:	logo type .png
Next Topic:	Image not displaying

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:33:08 CDT 2024