![Oracle forms get current item](https://kumkoniak.com/71.jpg)
Alas, foreground_color is not an allowed value in set_item_instance_property if I try to use it I get FRM-41383. With a lot of hunting around I have found that I should be using set_item_instance_property on the current record (set_item_property switches the whole column of the item back and forth in color).
![oracle forms get current item oracle forms get current item](https://4.bp.blogspot.com/-eOQN0Fh-cLU/V7Qb8qB3gVI/AAAAAAAAHks/RtIMVFjq6NEfAWDw4dZxk8Gw0-4-Fc9swCLcB/s1600/AssignmentSet_criteria.png)
There are values of the item displaying both above and below the criterion value, but no color change occurs, nor does any error message arise. I have ascertained by tracing that the trigger is actually invoked and that the correct path within the if block is taken. SYSTEM.CURRENTBLOCK system variable Syntax SYSTEM.CURRENTBLOCK Description The value that the SYSTEM.CURRENTBLOCK system variable represents depends on the current navigation unit: If the current navigation unit is the block, record, or item (as in the Pre- and Post- Item, Record, and Block triggers), the value of SYSTEM.CURRENTBLOCK is the name of the block that Form Builder is processing. Set_item_property (find_item(‘rwvbudg.rwvbudg_perc_used’), foreground_color, ‘black’) Set_item_property (find_item(‘rwvbudg.rwvbudg_perc_used’), foreground_color, ‘red’) Then click on the duplicate record button, this will duplicate all the values from the row above in the row you just created. Whether your application needs to include authentication using Oracle Access Manager, or communicate with Web Services, or run reports in Oracle. Click on the option insert new record, this will create an empty row just beneath the record you selected. Using the latest version you can easily integrate with nearly any modern or legacy technology your application requires. I have inserted the following PL/SQL code in the trigger post-change of the item. Oracle Forms isnt just about data-entry into an Oracle database anymore. I want to have its foreground color depend on its magnitude.
![oracle forms get current item oracle forms get current item](https://i0.wp.com/www.foxinfotech.in/wp-content/uploads/2018/07/emp1.jpg)
![oracle forms get current item oracle forms get current item](http://2.bp.blogspot.com/-lLsLM3TWybs/UNQ5W0KsppI/AAAAAAAADNw/0ZfCk3vPuo4/s1600/ScreenShot285.jpg)
One item in each record hights rwvbudg_perc_used.
![Oracle forms get current item](https://kumkoniak.com/71.jpg)