setting color of items

[bookouri]

Using developer 6i, how can I have an object's color attribute change at runtime based on changes of the data. For example, If I retrieve an employee file and the employee is inactive, I want the name to be highlited RED, if the employee is active I want it to be green etc... I know I need a trigger in a couple of places but I dont know the pl/sql to change the color settings.

thanks for any help..

 

[lewisp]

Use SET_ITEM_INSTANCE_PROPERTY in a POST-QUERY trigger.

 

[bookouri]

thanks, as usual, I would never have figured out where to begin looking without help...

 

[BJCooperIT]

Setting the color will only work well when 1 row is displayed on the form. If you have a multi-row block, then the entire column will be set to the color of the last SET_ITEM_PROPERTY.

By placing the code in the POST-QUERY then the column color reflects the status of the last queried employee.

If this is a single-row block where you allow the user to move from record to record (NEXT_RECORD/PREVIOUS_RECORD) then you might want to use the ON-NEW-RECORD-INSTANCE trigger instead.

 

[lewisp]

SET_ITEM_INSTANCE_PROPERTY only affects a single row in a multi row block. Try this in POST-QUERY

SET_ITEM_INSTANCE_PROPERTY('block.item',To_NumberSYSTEM.TRIGGER_RECORD),VISUAL_ATTRIBUTE,'your visual attribute');

 

[BJCooperIT]

Thanks, I stand corrected.

 

[lewisp]

No problem