every second record with another background color (second part)

[prosuc]

This thread is a rply of thread259-877570

The lewisp's solution work fine, but I want to highlight the current record with another color, but when I stay in a record with another background color activated by the trigger POST-QUERY, the current record's color don't change.

Thanks.
Pablo.
(sorry for my english)

 

[sem]

Try to use :SYSTEM.TRIGGER_RECORD instead of :SYSTEM.CURSOR_RECORD

Regards, Dima

http://seminihin.narod.ru

 

[prosuc]

Hi, Dima.

I don't have problems with the system variable, realy I don't know why Forms don't change the current record apereance thought I use the right property (I think).

POST-QUERY trigger on the block.
IF MOD(TO_NUMBERSYSTEM.TRIGGER_RECORD),2) = 0 THEN
SET_ITEM_INSTANCE_PROPERTY ('block_name.item_name,
,CURRENT_RECORD,VISUAL_ATTRIBUTE,'visual_attribute_back_green');
END IF;



in the field I set the current record visual attribute group with "visual_attribute_back_yelow"

Forms keep the color green in the current record.

Thanks.
Pablo

 

[sem]

How do you calculate CURRENT_RECORD value?

Regards, Dima

http://seminihin.narod.ru

 

[prosuc]

I just use the parameter named CURRENT_RECORD.

 

[sem]

Ok, but do you restore your initial visual attribute?

IF MOD(TO_NUMBERSYSTEM.TRIGGER_RECORD),2) = 0 THEN
SET_ITEM_INSTANCE_PROPERTY ('block_name.item_name,
,CURRENT_RECORD,VISUAL_ATTRIBUTE,'visual_attribute_back_green');
else
SET_ITEM_INSTANCE_PROPERTY ('block_name.item_name,
,CURRENT_RECORD,VISUAL_ATTRIBUTE,'DEFAULT');

END IF;

Regards, Dima

http://seminihin.narod.ru

 

[prosuc]

Thanks for your help, Dima.