Oracle Apex 4.2.4仅显示未保存到数据库的字段 [英] Oracle Apex 4.2.4 Display only fields not saved to database

问题描述

我正在使用动态操作，根据从另一个表中提取的人员的ID(提取人员的部门，员工编号等)，将数据自动填充到字段中.如果我将自动填充的字段保留为可编辑状态，则此方法很好，但是我希望这些字段为仅显示"，以便输入数据的人无法对其进行编辑.这就是使用动态动作的全部原因.当我将字段设置为仅显示"时，数据永远不会保存到表中，因此当我在记录上运行报表时，这些字段为空白.有没有一种方法可以使这些字段填充数据库，但仍不可编辑.我是否需要在幕后"运行另一个进程来填充它们，就像在提交"进程一样?

I am using a dynamic action to auto fill data into fields based on the ID of a person that is being pulled from another table (which pulls the person's dept, employee#, etc). This works fine if I leave the auto populated fields editable, but I want these fields to be 'display only' so that the person entering the data cannot edit it. That's the whole reason for using dynamic action. When I set the fields to 'display only', the data never gets saved to the table so the fields are blank when I run a report on the record. Is there a way to get these fields to populate the database and still not be editable. Do I need to run another process 'behind the scenes' to get them populated, like with an 'on submit' process?

推荐答案

使用文本字段，然后将"HTML表单元素属性"设置为 readonly = 只读"； .

Use Text field and then set the "HTML Form Element Attributes" with readonly="readonly";.

这篇关于Oracle Apex 4.2.4仅显示未保存到数据库的字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！