ما المقصود في SYSTEM.MESSAGE_LEVEL ومتى نستخدمها

:SYSTEM.MESSAGE_LEVEL := 10;
COMMIT;
:SYSTEM.MESSAGE_LEVEL := 0;
وما المقصود في RAISE FORM_TRIGGER_FAILURE ومتى نستخدمها

RAISE FORM_TRIGGER_FAILURE;

first : system.message_level

لمنع ظهور الرسائل التي تصدر عن الاوراكل، ولها مستويات 0, 5, 10, 15, 20, 25
والجملة التي كتبتها معناها عند اجراء عملية التخزين لا تظهر لي رسال "تمت عملية الحفظ" وبمعني آخر هي تعطيل للرسائل.

second : raise form_trigger_failure;
تكتب على الأكثر في جزء ال exception وتعني عدم استمرار تنفيذ الجمل التي تليها
مثلا لو انك اردت تنفيذ معادلة معينة اذا كا ن النتائج = موجب تريد الاستمرار في العمليات اما اذا كان الناتج سالب تريد التوقف فهذه تستخدم فيه الريز


اتمنى ان اكون قد افدتك
وبالتوفيق

تم تعديل 18 يناير 200521 سنة بواسطة m_zahran1977

Controlling System Messages
You can prevent system messages from being issued, based on their severity level. Form Builder classifies every message with a severity level that indicates how critical or trivial the information is; the higher the numbers, the more critical the message.
There are six levels of message severity that you can affect, listed here in increasing order of severity.
Level Message Description
0 All types of messages from the other levels of severity.
5 Reaffirms an obvious condition
10 Indicates that the end user has made a procedural mistake
15 Declares that the end user is attempting to perform a function for which the form is not designed.
20 Indicates a condition where the end user cannot continue an intended action due to a problem with a trigger or another outstanding condition
25 Indicates a condition that could result in the form performing incorrectly.
>25 Indicates a message severity level that you cannot suppress via the SYSTEM.MESSAGE_LEVEL system variable

In a trigger, you can specify that only messages above a specified severity level are to be issued by the form. You do this by assigning a value to the system variable MESSAGE_LEVEL.
Form Builder then only issues messages that are above the severity level defined in this variable. The default value for MESSAGE_LEVEL (at form startup) is 0. This means that messages of all severities are displayed.

مع تحياتى
اسامه سليمان
القاهرة