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

sanjeevkumar2010
Profile Answers by sanjeevkumar2010 Questions by sanjeevkumar2010
Oct 20th, 2010
6
7034

Questions by sanjeevkumar2010

Oracle Forms 4.0

Answer

Showing Answers 1 - 6 of 6 Answers

SANJIT

Jan 20th, 2013

Code
SET_ITEM_PROPERTY(ACCOUNT_MASTER.ACCT_NO,CURRENT_ROW_BACKGROUND_COLOR,r100g50b0);


 


SET_ITEM_PROPERTY(ACCOUNT_MASTER.ACCT_NO,CURRENT_ROW_FOREGROUND_COLOR,r100g100b88);

asifinet
Profile Answers by 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.