包括有关我的动态操作的警报消息 [英] Including alert message for my dynamic Actions

问题描述

我在oracle apex中有一组文本字段项:

I have a set of text Field items in oracle apex:

• 订单号
• 修订号

打开报告时，应隐藏修订.

When we open the report, revision should be hidden.

仅当用户输入唯一的订货号(非重复的订货号)时，修订号才可见.

Only when the user enters unique order number (non-duplicate order numbers), revision number should be visible.

如果他输入重复的订单号，则应隐藏修订号.

If he enters duplicate order number, revision number should be hidden.

我已经创建了这些动态动作，并且效果很好.

I have created these dynamic actions and it is working fine.

如果订单号重复，我需要发出一个警告，说这是重复的值"吗?在下面创建的动态操作中，我应该在哪里包含警报消息?

If the order number is duplicate I need to put a alert saying "This is a Duplicate value"? Where do I include the alert message in the dynamic actions I have created below?

顺便说一句，我的动态动作运行良好.我只需要针对以下动态操作容纳警报消息:

Incidentally, my dynamic actions are working fine. I just need to accommodate the alert message for the following dynamic action:

第1步.创建三个页面项

Step 1. Create three Page Items

1. P1_ORDER_NO-文本字段
2. P1_REVISION_NO-文本字段
3. P1_ENABLE_DISABLE_REVNO-隐藏，值受保护-否

第2步.创建3个动态操作

Step 2. Create 3 Dynamic Actions

1)在页面加载时禁用修订号

1) Disable revision number on page load

Event - Page Load
Action - Disable
Fire When Event Result Is  - True
Selection Type - Item
Item - P1_REVISION_NO

2)检查重复的订单号

2) Check duplicate order number

Event - Change
Selection Type - Item(s)
Item(s) - P1_ORDER_NO
Condition - is not null

Action - Execute PL/SQL Code
Generate opposite false action - Unchecked
Fire When Event Result Is  - True
Fire on page load - Unchecked
Stop Execution On Error - Checked
Wait for Result - Checked
PL/SQL Code -
declare  
l_count number;  
begin  
select count(*) into l_count  
from emp  
where empno = :P1_ORDER_NO;  

if l_count > 0 then  
:P1_ENABLE_DISABLE_REVNO := 1;  
else  
:P1_ENABLE_DISABLE_REVNO := 0;  
end if;  
end;  

Page Items to Submit = P1_ORDER_NO
Page Items to Return  = P1_ENABLE_DISABLE_REVNO

3)启用和禁用修订号

3) Enable and Disable Revision Number

Event - Change
Selection Type - Item(s)
Item(s) - P1_ENABLE_DISABLE_REVNO
condition - greater than or equal to
value  - 1

Action - Disable
Fire on Page Load - Unchecked
Generate opposite false action - checked
Selection Type = Item(s)
Item(s) - P1_REVISION_NO

推荐答案

您可以向第3个事件添加第二个动作:

You can add a second action to the 3rd event:

• 类型=警报
• 文本=这是重复值

这篇关于包括有关我的动态操作的警报消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！