Link to home
Start Free TrialLog in
Avatar of Anupama Misra
Anupama Misra

asked on

Search form

I want to select a row,when we select a row colour of row will change what is the code
Avatar of flow01
flow01
Flag of Netherlands image

You may not need code at all.
I don't remember if they following properties where already available in forms6i.  
But check the current_record_visual_attribute_group in your forms properties and  in your block_properties.
For coding check the set_form_property or block_property build-in options
CURRENT_ROW_BACKGROUND_COLOR ,
CURRENT_ROW_FOREGROUND_COLOR
and other CURRENT_ROW options.
But for a consistent behaviour  you might use  a template form with visual attributes to use by reference in all your forms.
(maybe it's already there , but not with the colors you want)
you can add the following to the post-query block trigger:

SET_ITEM_INSTANCE_PROPERTY ('adv_order_progress.adv_action_out',CURRENT_RECORD, VISUAL_ATTRIBUTE , '<your_visual attribute>');

obvs...replace <your visual attribute> with your actual visual attribute you want to update...

hope this helps.

JT
Please describe exactly what you mean by this: "I want to select a row".  Does that mean:
1. You want to query just one row in an Oracle Forms database block?
or
2. After multiple records have been queried in a multi-record, Oracle Forms database block, you want to manually navigate (down arrow) to a particular record?
or
3. Something else?

Also, please tell us, is this an Oracle Forms question?  If yes, which version of Oracle Forms do you have?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.