Ive been building a application that compares snapshots of tables, and have the code down to isolate the changes - now I need to highlight the background of the changed cells in a grid datawindow.
I am flagging the changed columns by setting the item status to datamodified! on the columns that were changed.
Now I need to create a global function I can call from a datawindow expression for the background color (like gf_getitemstatus (row, col) ) which will get the Status 1 when modified.
My questions is I assume I can get the row value with getRow() - how do I get the column number (ID) and return that as a number? I imagine I can hardcode the column number but was looking for a general way.
you're welcome.
Default-value "wins" when Expression can't compute for whatever reason.
When your expression uses IF or CASE the ELSE-expression usually ends up being the fallback value (aka. default). Sometimes that ELSE-expression cannot compute - in that case the initial Default-value takes effect.