>I have a grid that is based on a table with 3 columns,
>NAME C(40)
>PRICE N(12,2)
>BG I
>
>The first 2 columns are shown in the grid.
>The first column has TABLE.BG as DynamicBackColor
>
>The VALID clause for PRICE changes BG to be red for >$100, otherwise it is white.
>
>However, when I enter a price and cursor-down into the next line, I want it to update the color of the NAME column for that previous record to update its color, which it doesn't do right away.
>
>Only when I cursor back up onto that line and then cursor back down again, it updates.
>
>I've tried a bunch of things, including triggering grid.refresh() in AFTERROWCOLCHANGE or BEFOREROWCOLCHANGE, but no success.
>
>Does anyone have an idea on how to fix that?
>
>Thanks so much in advance.
>
>hs
Basically, you don't need to keep color in table. Instead, set dynamicbackcolor on some generic method:
Grid.SetAll("DynamicBackColor","0+thisform.getrowcolor(mytable.price)","Column")
It should work, even without Refresh.
Edward Pikman
Independent Consultant