Show_alert is used to display model window messages in Oracle Forms and Find_alert searches the list of valid alerts in Form Builder, when the given alert is located, the subprogram returns an alert ID. You must return the ID to an appropriately typed variable, define the variable with a type of Alert.

Example

Show a user-warning alert. If the user presses the OK button, then make REALLY sure they want to continue with another alert.

See also: Display Modal Window Messages Using Alerts
 http://www.foxinfotech.in/2015/02/using-single-alert-for-messages-and-confirmation-messages.html

Declare

al_id       alert;

al_button   NUMBER;

BEGIN

al_id := FIND_ALERT ('user_warning');

IF ID_NULL (al_id)

THEN

MESSAGE ('user_warning alert does NOT exist');

RAISE form_trigger_failure;

ELSE

/*

** Show the warning alert

*/

al_button := SHOW_ALERT (al_id);

/*

If user pressed OK (button 1) then bring up another alert to confirm -- button mappings are specified in the alert design

*/

IF al_button = alert_button1

THEN

al_id := FIND_ALERT ('are_you_sure');

IF ID_NULL (al_id)

THEN

MESSAGE ('the alert NAMED:are you sure ? does NOT exist');

RAISE form_trigger_failure;

ELSE

al_button := SHOW_ALERT (al_id);

IF al_button = alert_button2

THEN

-- do some task

erase_all_employee_records;

END IF;

END IF;

END IF;

END IF;

END;

Follow to get notifications for tutorials with free source code, thanks.

Show_Alert and Find_Alert in Oracle Forms

Reviewed by Mridula Joshi on

Mar 22

Rating:
5

最新文章

  1. 数据结构与算法JavaScript (四) 串(BF)
  2. Mac Pro 编译安装 Redis-3.2.3
  3. 【C#】在窗体中水平居中的控件,到了XP下不居中的解决办法
  4. 限制Input输入类型的常见代码集合
  5. asp.net项目中通过Web.config配置文件及文件夹的访问权限---forms
  6. 快速构建Windows 8风格应用20-MediaElement
  7. Linux-ubuntu安装过程讲解
  8. 在dropwizard中使用feign,使用hystrix
  9. pymysql安装
  10. SpringBoot(二)_项目属性配置
  11. 剑指Offer-表示数值的字符串
  12. STL库学习笔记(待补充QAQ
  13. 【centos】 error: command 'gcc' failed with exit status 1
  14. Window 任务栏清除历史记录
  15. nginx启动重启与升级以及检测配置文件
  16. ElasticSearch 2 (25) - 语言处理系列之同义词
  17. 岭回归&Lasso回归
  18. python基础之2
  19. Nutch 快速入门(Nutch 2.2.1+Hbase+Solr)
  20. SQL全文搜索引擎 Sphinx

热门文章

  1. C语言编程题002
  2. ogre3D学习基础4 -- 网格工具与硬件缓存
  3. HTML 长文本换行
  4. Leetcode 540.有序数组中的单一元素
  5. Leetcode 523.连续的子数组和
  6. ActionContext和ServletActionContext小结
  7. poj2488 A Knight's Journey裸dfs
  8. 【bzoj4825】[Hnoi2017]单旋 线段树+STL-set
  9. 编写可移植的PHP代码
  10. SPOJ COT2 - Count on a tree II(LCA+离散化+树上莫队)