Re: Problems

Benjamin, The only way I know how to do this is to use a WHEN-BUTTON-PRESSED trigger. For each of the buttons you wish to deactivate, you would have to put the following code into the trigger: if :SYSTEM.FORM_STATUS = 'CHANGED' THEN

   message('Please clear or save record....');    raise form_trigger_failure;
end if;

(I may not have the correct syntax etc..) There is no way that I know of to 'grey out' or remove buttons from a canvas.
Cheers, Tracey

Benjamin H. Tay wrote:
>
> Hi,
>
> I am a new Oracle learner.....I have something would like to share with
> someone....
>
> 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 change a data (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? Any codes provided will be
> greatly appreciated! Thanks in advance!
>
> Sincerely,
>
> Benjamin Tay
> =======================
> A New RDBMS Learner
> ****************/////000\\\\\
Received on Mon Oct 06 1997 - 00:00:00 CEST