>I have a statement that looks like this:
>
WITH myColumn
> .DYNAMICFORECOLOR='IIF(sortkey="A",clr_Black,'+STR(.BACKCOLOR)+')
>ENDWITH
>
>clr_Back is defined in a #DEFINE statement in a header file set in _INCLUDE and exists at the point of the reference to .DYNAMICBACKCOLOR ... what am I missing?
>
>Thanks
1) You've a typo in your expression
2) clr_Black is in a string and shouldn't expand with #define
Try this:
MessageBox("clr_Black")
WITH myColumn
.DYNAMICFORECOLOR='(IIF(sortkey="A",'+Transform(clr_Black)+','+STR(.BACKCOLOR)+'))'
ENDWITH
Cetin