Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cant get Nested IIF to work in Grid Init
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00433590
Message ID:
00433609
Views:
18
Gerard,

>I am trying to set dynamic background color of Grid Rows:
>For each loColumn in This.Columns
> With m.loColumn
> .DynamicBackColor = "Iif(Mem.Mem_Status='SUP',RGB(255,0,0),;
> IIf(Recno() <> This.inCurrentRecNo,RGB(255,255,255),RGB(0,255,0))"
> EndWith
>EndFor

Since, the IIF statement is a text string not an expression you need a close quote before the at the end of the line.

As in:
   .DynamicBackColor = "Iif(Mem.Mem_Status='SUP',RGB(255,0,0),"+;
      "IIf(Recno() &lt;&gt; This.inCurrentRecNo,RGB(255,255,255),RGB(0,255,0))"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform