We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Oracle Forms 10g: How to avoid record navigation?

jocafi
jocafi asked
on
Medium Priority
3,422 Views
Last Modified: 2012-05-11
How to avoid record navigation in Oracle Forms 10g?

My form has 5 blocks: 3 Control-Blocks and 2 Blocks where the user can navigate through the records.

The user must remain in the same record when the focus is on the first 3 Control Blocks. Rules:

1) If he presses the key (Page Down) to navigate to the next record, nothing happens.

2) If he presses the key (Page Up) to navigate to the previous record, nothing happens.

3) If he presses the button using the mouse to navigate to the next record, nothing happens.

4) If he presses the button using the mouse to navigate to the previous record, nothing happens.

5) If he presses the button using the mouse to insert or delete a record, nothing happens.

Thanks!

p.s.: Please assist my other questions.
Comment
Watch Question

IT-specialist
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Many Thanks, flow01. It works !

I put the code below (adjusting the code for each key) in the triggers KEY-NXTREC, KEY-PRVREC, KEY-DOWN, KEY-UP:

 -- normal DB blocks
 if :system.trigger_block in ('COLABORADORES','PARTICIPANTES') THEN
             NEXT_RECORD;
 else
          -- control blocks
         -- disable normal functioning of the key
    null;    
 end if;

I adjusted the code above in other triggers too.
Mark GeerlingsDatabase Administrator
CERTIFIED EXPERT

Commented:
That may confuse the users (leaving them to wonder why the navigation keys work in some blocks, but not others), but it should work.  I would rather see the trigger not just do "null:" when you want to disable it, but display an alert to indicate that the requested navigation event is not available in this block.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.