Background_color

In the Manual datablock , we will get records from database then I need to get each row in different color ......
I am using the set_item_property('blockname.item',current_row_background_color,'red');

plz help me.............

Questions by sanjeevkumar2010

Showing Answers 1 - 2 of 2 Answers

SANJIT

  • Jan 20th, 2013
 

Code
  1.  

  Was this answer useful?  Yes

asifinet

  • Feb 15th, 2013
 

You can use SET_BLOCK_PROPERTY(blk_name,record_no, CURRENT_RECORD_ATTRIBUTE,Visual_attribute_name);

Must create two Visual Attributes one with yellow background color one with default name them VA_YELLOW,VA_DEFAULT in Object Navigator in Oracle Forms.

Get the Record No by using System.Cursor_record on WHEN-NEW-RECORD-INSTANCE Trigger. Always keep the record number current and previous in global.variables let say cursor_previous_global_variable, cursor_current_global_variable and Set the visual attribute VA_DEFAULT to previous record upon navigating to the new current record and set the VA_Yellow to current record in the Non Block Item.

CURRENT_RECORD_ATTRIBUTE Specify the VARCHAR2 name of
a named visual attribute to be associated with the given block. If the named
visual attribute does not exist, you will get an error message.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions