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

[A. Razzak Memon]

At 05:38 PM 10/14/2010, Luc Delcoigne wrote:

Razzak,
the type of the BLOB field is LONG VARCHAR


Luc,

In that specific case, you may try the following update command:

   -- Example 01
    UPDATE tablename SET +
    RowBackgroundColor = 'WHITE', RowFontColor = 'RED' +
    WHERE (SLEN(ColumnNameWithBlobdata)) = 0
    UPDATE tablename SET +
    RowBackgroundColor = 'WHITE', RowFontColor = 'GREEN' +
    WHERE (SLEN(ColumnNameWithBlobdata)) > 0
    CLS
    BROWSE USING formname ...

    -- Example 02
    UPDATE tablename SET +
    RowBackgroundColor = 'SILVER', RowFontColor = 'BLACK' +
    WHERE (SLEN(ColumnNameWithBlobdata)) = 0
    UPDATE tablename SET +
    RowBackgroundColor = 'WHITE', RowFontColor = 'BLACK' +
    WHERE (SLEN(ColumnNameWithBlobdata)) > 0
    CLS
    BROWSE USING formname ...

    -- Example 03
    UPDATE tablename SET +
    RowBackgroundColor = '[R124,G83,B23]', RowFontColor = 'WHITE' +
    WHERE (SLEN(ColumnNameWithBlobdata)) = 0
    UPDATE tablename SET +
    RowBackgroundColor = '[R169,G176,B209]', RowFontColor = 'BLACK' +
    WHERE (SLEN(ColumnNameWithBlobdata)) > 0
    CLS
    BROWSE USING formname ...

Have fun!

Very Best R:egards,

Razzak.