Home » Developer & Programmer » Forms » HOW TO CHANGE ITEM PROPERTY FOR TABULAR (FORMS 10G )
icon5.gif  HOW TO CHANGE ITEM PROPERTY FOR TABULAR [message #664818] Sat, 05 August 2017 19:12 Go to next message
HELMATION
Messages: 3
Registered: August 2017
Junior Member
PLEASE I HAVE problem - I WILL DESCRIBE THE REQUIREMENT DIRECTLY

- I CREATED PROGRAM UNIT IN FORMS TO FETCH SELECTED DATA FROM TABLE IN TABULAR ITEMS - AND ONE OF THOSE TEXT ITEMS IS 'DATE TYPE'
SO I WANNA CREATE TRIGGER TO CHANGE ITEM PROPERTY "BACKGROUND COLOR" IF THE FETCHED DATE IN THIS TABULAR TEXT ITEM IS < SYSDATE ..!!
Re: HOW TO CHANGE ITEM PROPERTY FOR TABULAR [message #664820 is a reply to message #664818] Sat, 05 August 2017 20:14 Go to previous message
HELMATION
Messages: 3
Registered: August 2017
Junior Member
PROBLEM SOLVED ..
BY USING TRIGGER
POST_RECORD - BLOCK LEVEL

BEGIN
IF :C_MONTH < SYSDATE THEN
set_item_instance_property('C_MONTH', current_record, visual_attribute, 'VA' );
END IF;
END;
Previous Topic: Cancel process
Next Topic: How to get to the last record or refreshing a block...
Goto Forum:
  


Current Time: Thu Mar 28 20:38:54 CDT 2024