OraFAQ Forum: Forms » *Stoping alert 'Do you want to save the changes you have made? How to ?'*

Home » Developer & Programmer » Forms » *Stoping alert 'Do you want to save the changes you have made? How to ?'*

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

*Stoping alert 'Do you want to save the changes you have made? How to ?'* [message #85158]

Sat, 05 June 2004 01:17

Robin ( Bangladesh)
Messages: 25
Registered: September 2002

Junior Member

Experts,

�� A form is used only for update data of a table. After running form user selecting�value�into a text box from LOV,�then 'key_next_item' trigger execute_query using selected value by 'default where caluse'.�

Form is working well, but my problem is when�'key_next_item' trigger executing, an alert�appeared with�messge 'Do�you want to save the changes you have made?'. I want to stop this message.��

I am using developer2000 form Version 6.0.5.0.2

Thanks

Robin

�

Report message to a moderator

Re: *Stoping alert 'Do you want to save the changes you have made? How to ?'* [message #85159 is a reply to message #85158]

Sat, 05 June 2004 02:15

Robert Baron
Messages: 7
Registered: May 2002

Junior Member

Use the following syntax:

:SYSTEM.MESSAGE_LEVEL := '25';
COMMIT;
:SYSTEM.MESSAGE_LEVEL := '5';

Report message to a moderator

Re: *Stoping alert 'Do you want to save the changes you have made? How to ?'* [message #85163 is a reply to message #85158]

Sat, 05 June 2004 03:36

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Hi,
It seems that your form is not in enter-query mode.

Regards
Himanshu

Report message to a moderator

Re: *Stoping alert 'Do you want to save the changes you have made? How to ?'* [message #85183 is a reply to message #85163]

Mon, 07 June 2004 20:12

Robin ( Bangladesh)
Messages: 25
Registered: September 2002

Junior Member

Thanks, Then how can I enforce my form to enter in query mode ?

Robin

Report message to a moderator

Re: *Stoping alert 'Do you want to save the changes you have made? How to ?'* [message #85186 is a reply to message #85183]

Mon, 07 June 2004 22:33

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Hi,
In your new-form-instance send the Cursor to first navigable item of your First Querable block and then add Enter_Query; just below it.
By default your form will open in Enter-query mode.

Also can you please give me the code which you have written on your key-next-item.
Have you written something there which calls Commit or Rollback?

HTH
Regards
Himanshu

Report message to a moderator