如何在Oracle Apex中根据正确或错误案例隐藏文本字段项 [英] How to hide text field item based on true or false cases in Oracle Apex
问题描述
我在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.
推荐答案
一个简单的(虽然不是防弹的)解决方案是在订单号"项上创建动态操作"，当更改"时，将对数据库发出查询以检查订单号是否已经存在；如果找到，它将隐藏修订版号"项目，否则将显示它.
A simple (though not bullet-proof) solution is to create a Dynamic Action on the Order Number item that, when Changed, issues a query on the database to check if the order number already exists; if found, it hides the Revision Number item, otherwise it shows it.
您希望确保数据库的订单号列上有合适的索引，以便查询尽快返回.
You would want to ensure there is a suitable index on the order number column on the database so that the query returns as fast as possible.
如果两个人同时在屏幕上输入相同的订单号，查询将不会看到该订单号，因此不能保证此方法始终能正常工作.
If two people are in the screen at the same time, and enter the same order number, the query will not see the order number so this method is not guaranteed to always work perfectly.
这篇关于如何在Oracle Apex中根据正确或错误案例隐藏文本字段项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
