[RBASE-L] - Re: Change Row Color

[Gustavo Urquizo]

Razzak,

Everything works fine except for the first row that by default is grey,
is there a way to suppress this?

Gustavo.

-----Original Message-----
From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of A.
Razzak Memon
Sent: Tuesday, March 27, 2012 9:54 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Change Row Color

At 11:40 AM 3/27/2012, Gustavo Urquizo wrote:

>Is there a way to change the row color on a DB Lookup List View based
>on a column result?, i.e. if column='Fail' change the row color to red.

Gustavo,

Yes, you can use the "Color Rows" option of Variable Lookup List View
Lookup Setting properties to achieve your goal.

Here's how:

Form Designer | Variable Lookup List View Properties | Lookup Settings

Based on the condition, you will have to either create a dynamic VIEW
to associate with Variable Lookup List View and assigned columns for
"Row Background Color Field" and "Row Font Color Field", or add two
columns in the table associated with Variable Lookup List View that
can be updated conditionally to assign "Row Background Color" and
"Row Font Color".

So, in your case, for learning sake, add the following two columns in
the table that is associated with Variable Lookup List View:

. RowBackgroundColor TEXT (16)
. RowFontColor TEXT (16)

Then, you can update the values prior to "EDIT USING formname", OR you
can use these two columns as "Computed" columns, as follows:

-- Example 01
    RowBackgroundColor = (IFNULL(columnname,'RED',NULL))
    RowFontColor = (IFNULL(columnname,'WHITE',NULL))

-- Example 02
    RowBackgroundColor = (IFEQ(columnname,'Fail','RED',NULL))
    RowFontColor = (IFEQ(columnname,'Fail','WHITE',NULL))

That's all there is to it!

Let me know if you need a sample application to demonstrate the use of
such options in R:BASE eXtreme 9.1 and 9.5.

Very Best R:egards,

Razzak.