Changing the Row Colour

[make]

Hi,

i have successfully build up a temp-temp table. Now i want to change the background colour of then field tt.menge when the value is over 100.
Can anyone help me ?

Thanks for any help.
Make


for each tt
break By tt.kunde By tt.menge:
ACCUMULATE tt.menge(SUB-TOTAL BY tt.kunde).
IF LAST-OF(tt.kunde)
and (tt.kunde <> 0) THEN do:
create mytable.
mytable.kunde = tt.kunde.
mytable.menge = (ACCUM SUB-TOTAL BY tt.kunde tt.menge).
find first kunden where kunden.k-nr = tt.kunde no-lock no- error.
if available Kunden then
mytable.name = kunden.name1.
end.
end.

 

[atarba]

I supose you use a browser to display temp-table records, so here it is a code that will change the bgcolor of the cell:

ON ROW-DISPLAY OF {&browse-name} IN FRAME {frame-name}:
if menge > 100 then
menge:bgcolor in browse {&browse-name} = 15.
END.