Solved

FORM ENHANCEMENT

Posted on 1997-10-05
4
860 Views
Last Modified: 2008-03-03
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!
0
Comment
Question by:htay
  • 3
4 Comments
 

Author Comment

by:htay
ID: 1080644
Edited text of question
0
 

Author Comment

by:htay
ID: 1080645
Edited text of question
0
 

Author Comment

by:htay
ID: 1080646
Edited text of question
0
 
LVL 1

Accepted Solution

by:
yesnaud earned 100 total points
ID: 1080647
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Finace 3 67
Oracle RAC 12c 8 60
Wrap Oraccle SQL*Plus executable Command 4 70
data lookup in Oracle - need suggestions 55 104
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now