[RBASE-L] - re: conditional var listview background color

[Luc Delcoigne]

Thanks, Larry,

I'll give it a try rightaway.

Luc D.


From: Lawrence Lustig 
Sent: Thursday, October 14, 2010 8:24 PM
To: RBASE-L Mailing List 
Subject: [RBASE-L] - re: conditional var listview background color


<< 
e.g. : Row where BLOBfield is empty : background color row = white
         ROw where BLOBfield is not empty : background color row = light grey

Can anyone give me a hint ?
>>


Create a VIEW on which you will base the listview:


CREATE VIEW MyView (MyCol1, MyCol2, BackgroundColor) AS +
    SELECT MyCol1, MyCol2, (IFNULL(MyBlobCol, 'WHITE', 'SILVER'))
    FROM MyTable


Then, link the listview to this view (not the original table) and in the Row 
Background Color Field dropdown select the column BackgroundColor.


By coincidence, I was working on just such a listview scheme (I also change the 
font color to indicate another dimension of the data) when I read your message.
--
Larry