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

[Luc Delcoigne]

Razzak,

this doesn't seem to work. When I open the BLOB in the editor I can see 
there is still one paragraph (?) sign remaining.
When I delete the value manually in the table then the code works well.
But testing on the SLEN(BLOB) = 0 does not work.

Getting some sleep now .....it's already midnight overhere.

thanks for your help.

I really like working with R:base.

Everything really is possible (with a little help from my R:friends).

Goodnight,

Luc D.

--------------------------------------------------
From: "A. Razzak Memon" <raz...@rbase.com>
Sent: Thursday, October 14, 2010 11:43 PM
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
Subject: [RBASE-L] - re: conditional var listview background color

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.