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 ..!!

Report message to a moderator

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;

Report message to a moderator

Previous Topic: Cancel process
Next Topic: How to get to the last record or refreshing a block...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Mar 11 10:26:48 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.