FORM ENHANCEMENT

Hi,
I was trying to build a form application with several text boxes, and navigation buttons.  However, I would like to enhance some security integration as follows:

When I willingly or unwillingly key down a text box (when I hit the keyboard, exclude mouse click to the text box), I would like to disable all the navigation buttons (next, previous, first, and last), then CANCEL and SAVE buttons will be active that can force users click one of them...So when I click CANCEL will "clear_record" and SAVE will commit_record".

Can anyone help?  In what trigger so I enforce?  Since I have tried several KEY bilt-in functions, that is no one works for my needs.  Any codes provided will be greatly appreciated!  Thanks in advance!
htayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

htayAuthor Commented:
Edited text of question
0
htayAuthor Commented:
Edited text of question
0
htayAuthor Commented:
Edited text of question
0
yesnaudCommented:
Well not sure if I understand what you want but basically you want the user to save after each record he enters....

so what can u do ?

Create key-down, up, nextrec, prevrec triggers at the block level and check the record status with system.record_status, if = 'INSERT' or 'CHANGED' Then force the user to press cancel or save with either showing an alert message box with two buttons cancel and save or simply display a acknowledgement message to the user asking him to save the record.....

i.e. Key-down trigger:

declare
  button Number;

Begin
  if :system.record_status in ('INSERT','CHANGED') then
    button ;= show_alert ('CANCEL_SAVE');
    if button = 88 Then -- I think 88 is for the button1 on the alert property...
      commit;
      down;
    Else
      clear_record (NO_VALIDATE);
      down;
    End If;
  End If;
End;

Ok If you have any problem yesnaud@fdgroup.co.uk

cya
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.