Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Forms question

user10991018Oct 21 2021 — edited Oct 22 2021

Hi I have a requirement for eg.
i have multi tab block one tab for dept and another is for EMP for eg.
when tab changed then the emp block will populate with data.
i set emp block property where clause is to execute where deptno=:parameter.deptno.
emp block shows multiple records in grid form for that deptno.

but i want to mask the null values with None
how to do in which trigger i can write.
i dont want to update the columns so i am using the non db items
and set synchronize property to db item name.
please advise thanks very much

right now the data is as below
deptno Empno ename startdate
10 101 test 2021-10-20
10 102 null null
10 103 null null

but i am looking the data to be
deptno Empno ename startdate
10 101 test 2021-10-20
10 102 None None
10 103 None None
thanks

Comments

Post Details

Added on Oct 21 2021
1 comment
132 views