[RBASE-L] - Re: Change Row Color

[jan johansen]

Check to see that you don't have ZEBRA stripe enabled.


-----Original Message-----
 From: "Gustavo Urquizo" <urquizo.gust...@toraymem.com>
 To: rbase-l@rbase.com (RBASE-L Mailing List)
 Date: Tue, 27 Mar 2012 11:31:28 -0700
 Subject: [RBASE-L] - Re: Change Row Color


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.