الانتقال إلى المحتوى

How To Suppress Forms Message "do You Want To Save


hana2005

Recommended Posts

dear brothers


assalamo alikom
i have learned in the forum about how to suppress oracle messages and errors
there was many solution proposed such as:
-system.message_level
-console_window
-on_message and on_error triggers
but they give solutions to some problems like frm-40400 message
but they don't resolve the problem for the message that arrive when we make changes and we want to close the window so they ask us "do you want to save changes"
i ask if there is one of the brothers in the forum who have a real and experimented solution to this problem

your brother in islam
thank you

رابط هذا التعليق
شارك

My Sister,,,,
in the first welcome in arab oracle site and you have tow problem
and i think this is solution :
1-for error message you can display this error i mean error code and error number and details
go to this link

Click here

2- about message frm-40400 this is message not for error this is tell you , you dont have any changes in your database i mean update ,insert or delete
so you can put this code for tell you if you want to save change or not
you can put it in level form that trigger name KEY-EXIT

/* if the previous commit was successful then the form status
    would not be CHANGED or INSERT  */
 if :SYSTEM.FORM_STATUS in ('CHANGED','INSERT') then 
    return(FALSE);
 else
    return(TRUE);
 end if;



and put this code in trigger name ON-COMMIT

commit_form ;
 if not form_success then
    raise form_trigger_failure ;
 end if ;



i hope this is explain help you
and you are welcome

تم تعديل بواسطة Admin05
رابط هذا التعليق
شارك

my brother admin05
i have tried your preposition about the message "do you want to save" but it doesn't work
and it return an error message
that return built in must be in a procedure or function

i hope that you or any one of our brother in the forum
have a real and experienced solution to
this problem
and thank you previously

رابط هذا التعليق
شارك

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   تمت استعادة المحتوى السابق الخاص بك.   مسح المحرر

×   You cannot paste images directly. Upload or insert images from URL.

جاري التحميل
×
×
  • أضف...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية