Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > Oracle > Forms Navigation problem (forms 4.5)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-15-07, 15:08
tmalone tmalone is offline
Registered User
 
Join Date: Aug 2002
Posts: 109
Forms Navigation problem (forms 4.5)

I have a form where the user enters data in various txtboxes. However, if the user accidentily presses an arrow key in one of these txtboxes, it moves them to a new blank record, as opposed to the next txtbox. Is there some sort of property on the block or item that needs to be turned off?


Reply With Quote
  #2 (permalink)  
Old 10-16-07, 02:20
Littlefoot Littlefoot is offline
Lost Boy
 
Join Date: Jan 2004
Location: Croatia, Europe
Posts: 2,717
One way to fix it is to create the KEY-DOWN trigger (it moves the focus to the next record); it should contain only one line of code: NULL; (i.e. don't do anything).

This would, though, prevent user from going up and down ALWAYS (which is not good as well), so you may decide to allow going up and down only if user is on the first or last item in a record. Otherwise, do nothing. Something like this: assume that 'LOC' is the last item in the 'DEPT' block:
Code:
if :system.cursor_item = 'DEPT.LOC' then down; else message('Disabled: you are not on the last item'); null; end if;

Default navigation in a block can be set only for the first or the last item in a record, and this navigation may be one of the following: same record, change record, change data block. See if any of this may be helpful to you.
Reply With Quote
  #3 (permalink)  
Old 10-16-07, 07:49
tmalone tmalone is offline
Registered User
 
Join Date: Aug 2002
Posts: 109
Thanks Littlefoot, I'll give that a try...
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On