>>>>I am trying to color cetain rows of a grid based on the value of a field. Where do I put the code to do this, I have tried changing the dynamicbackcolor property but this is not working.
>>>>
>>>You may try in to Grid.Init
>>>This.SetAll("DynamicBackColor","IIF(mycursor.myfield=1,16777215,0)","Column")
>>
>>This line of code says gives an error : Invalid value for dynamicbackcolor property. Any ideas why ?
>>
>>This.SetAll("DynamicBackColor",'iif(sch_route.rte_pavement_type="B",rgb(255,0,0),rgb(255,255,255))',"Column")
>
>Ian, for some reason, columns don't like the RGB function in their dynamic properties being assigned in code. Just replace your RGB function with the numeric equivalent.
Erik,
I'm using the 'rgb()' format in DynamicBackColor without a problem, unless I want to use variables instead of numbers ( as in rgb(n1,n2,n3) ). But if you know the different colors you want, there isn't a problem with using rgb(0,0,0) in an IIF() statement here.
Barbara