Hi,
I am getting a JSON with a TServerRequest, in the Complete Event.
Then I load the JSON to a dataset on the dataset.loadrows method.
Then dynamically I fill a grid, column by column with the data like so:

grid1.columns[0].header.caption := 'Device ID';
grid1.columns[0].dataColumn := 'deviceid';
grid1.columns[0].width := 80;

It works good, but I want to change the color for a row according to the value of one of the fields.  The change of color of course must be paired with the value if I click on the column title to sort up or down.

I have not found  a way to accomplish this, and need some example or suggestion please.
JD

jdforce wrote:
Actually the new requirement I was given is to color a single cell, containing a number, depending on the number it will be red, yellow or green. It is for alerting when some data is received.

<< It works good, but I want to change the color for a row according to the value of one of the fields.  The change of color of course must be paired with the value if I click on the column title to sort up or down.  >>

What you want is this event:

https://www.elevatesoft.com/manual?action=viewevent&id=ewb2&comp=TGridColumn&event=OnCellUpdate

Tim Young
Elevate Software
www.elevatesoft.com

> Actually the new requirement I was given is to color a single cell, containing a number, depending on the number it will be red, yellow or green. It is for alerting when some data is received.

In addition to Tim's hint, here a sample how to read the cell's data within the OnCellUpdate event:

   if ACell.Data = '0' then
   begin
      ACell.Font.Color := clRed;
      ACell.Font.Style.Bold := true;
   end
   else
   begin
      ACell.Font.Color := clBlack;
      ACell.Font.Style.Bold := false;
   end;

Uli

Thanks guys, will test that ASAP.