Luc,
Another solution is to make use of the property command.
It looks like this:
1. Define a variable which knows if the column is empty or not (e.g.
V_variable1)
2. Apply a componentid to the concerned field used in the form (e.g.
Component1)
3. Choose in the form option Tables | Add Remove tables | Table
settings | On row entry
In this EEP you can write a procedure like this:
IF V_variable1 IS NULL THEN
PROPERTY Component1 COLOR 'WHITE'
ELSE
PROPERTY Component1 COLOR 'LIGHT GRAY'
ENDIF
RETURN
When you enter a new row this procedure is executed.
Look for the possibilities of property the HELP. There is a link available
to an online help.
Succes,
Tony IJntema
From: [email protected] [mailto:[email protected]] On Behalf Of Luc
Delcoigne
Sent: donderdag 14 oktober 2010 20:52
To: RBASE-L Mailing List
Subject: [RBASE-L] - re: conditional var listview background color
Thanks, Larry,
I'll give it a try rightaway.
Luc D.
From: Lawrence <mailto:[email protected]> Lustig
Sent: Thursday, October 14, 2010 8:24 PM
To: RBASE-L Mailing List <mailto:[email protected]>
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
