Hi!
I do not think so. Here I used iif() too without a problem. When it is incorrect - it for sure will throw an error. If you have error handler or something like that - try to see if it is caught (though I doubt about that). Another reason is that somewhere in the system you have a functions "iif" defined. Or you have a field in the current alias called "iif". Or one of the "i" in the "iif" was from another language (and thus incorrect).
Could not be such mysterious.
>I don't know why I put it in the when method, I have moved it to the init. I checked the help for dynamicbackcolor and pasted in the code in their example and it worked, the difference appeared to be IIF was in caps. Once I put IIF in caps in my code it worked. Very strange....( a feature of 7 ?)
>
>Thanks
>Ian
>
>>Hi!
>>
>>Why you doing that in the When event (just noticed that)???
>>Do you want to do not show rows colored when grid has no focus?
>>Usually this code is in the Init of the grid.
>>
>>Just check if that code line is running at all as you suggested (put DEBUGOUT or messagebox() there or something like that).
>>
>>Also, when thid does not works, maybe, somewhere else this property (DynamicBackColor) is re-assigned?
>>
>>>I tried this , it does not appear to help. Were you able to make it work ?
>>>
>>>
>>>>Hi!
>>>>
>>>>See correction in bold. You have to use alias, because record source alias for grid could be not current when grid is refreshed.
>>>>
>>>>>I am converting a grid from 6 to 7. The following line of code is in the when method :
>>>>>This.column1.dynamicBackColor = "iif(alltrim(
MyAlias.loc_highway_group) = 'X',rgb(255,0,0),rgb(255,255,255))"
>>>>>
>>>>>It works fine in 6 , turning the column the appropriate color, but no color at all in 7.
>>>>>
>>>>>Anyone any ideas...
>>>>>
>>>>>Ian
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.