Generating display only output from a Form to Browser
Hello,
This is on Oracle forms 10g. And this is NOT Oracle EBS.
Bullets shown below explains the scenario and the requirement.
1. We have a display only form that looks like the image that is attached here.
2. I have a POST-QUERY trigger of the data block that does following.
begin
select first_name, salary into :departments.empname, :departments.sal
from hr.employees where employee_id = :departments.manager_id;
-- highlight as per your criteria
if :sal >= 10000 then
-- create highlight visual attribute with color of your choice to highlight
display_item('departments.empname', 'highlight');
else
-- create default1 visual attribute to restore to normal view