Help with forms 6i and making colors in fields
From: Rene S. Nielsen <renesn_at_image.dk>
Date: Sat, 17 Aug 2002 21:29:14 +0200
Message-ID: <3d5ea523$0$27853$edfadb0f_at_dspool01.news.tele.dk>
Hi
declare
felt varchar2(50) := :system.current_block||'.'||:system.current_item; værdi varchar2(50) := name_in(felt);
begin
if værdi = '2' then
Set_Item_Property(felt,VISUAL_ATTRIBUTE,'SORT_PA_GULT');
-- Message ('Lav teksten sort på gul'); -- English ** Make text black on
yellow
else
[Quoted] Set_Item_Property(felt,VISUAL_ATTRIBUTE,'DATA_NORMAL');
-- Message ('Lav teksten almindelig'); -- English ** MAke record default
color
end if;
end;
Date: Sat, 17 Aug 2002 21:29:14 +0200
Message-ID: <3d5ea523$0$27853$edfadb0f_at_dspool01.news.tele.dk>
Hi
[Quoted] [Quoted] I need some help to solve this problem.
[Quoted] I have a form, with a datablock built on a view. It's a multi row view (Numbers of rows displayed = 24)
What I need to do is make every line (Record) a seperate color, depending on [Quoted] the value in the record.
[Quoted] I have created a trigger (When-new-record-instance) with the following code.
declare
felt varchar2(50) := :system.current_block||'.'||:system.current_item; værdi varchar2(50) := name_in(felt);
begin
if værdi = '2' then
Set_Item_Property(felt,VISUAL_ATTRIBUTE,'SORT_PA_GULT');
-- Message ('Lav teksten sort på gul'); -- English ** Make text black on
yellow
else
[Quoted] Set_Item_Property(felt,VISUAL_ATTRIBUTE,'DATA_NORMAL');
-- Message ('Lav teksten almindelig'); -- English ** MAke record default
color
end if;
end;
[Quoted] But my problem is that this code, will make all the record black and yellow. [Quoted] [Quoted] And I only want the single record this color.
I know this can be done. I have seen it ons, but I don't have the code for it.
[Quoted] Any sugestions...
Please help
Regards
Rene S: Nielsen
Received on Sat Aug 17 2002 - 21:29:14 CEST