asked on

Oracle forms query

I have a code that sets values in the fields.

If v_load_drive_details_rec.total_drives > c1_rec.crew then
set_item_property(v_item_name3_c, VISUAL_ATTRIBUTE, 'VA_RED');
End if;

Its putting the color on all the fileds. But I wanted this only if the condition is satisfied. I have enclosed the picture for the one that needs to be color.

Help is appreciated.
code.txt
print-screen.JPG
expected.JPG

Mark Geerlings

I think you need to use: "set_item_instance_property" instead of "set_item_property". The difference is: "set_item_property" will affect all records in a multi-record block, while "set_item_instance_property" will only affect one one record (the current record).

anumoses

ASKER

If v_load_drive_details_rec.total_drives > c1_rec.crew then
set_item_instance_property(v_item_name3_c, CURRENT_RECORD,VISUAL_ATTRIBUTE, 'VA_RED');
End if;

Did not work.

ASKER CERTIFIED SOLUTION

Mark Geerlings

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anumoses

ASKER

I've requested that this question be deleted for the following reason:

None of the answers helped me. Please delete the question

Mark Geerlings

What "Did not work"? The "set_item_instance_property" command will do exactly what you asked for, if I understood your question correctly. I think your question is basically: "how can I change the background color for one field (item) of just one record in a multi-record block"?