In the listview I Use the BLOB field itself is not included, only in the underlying view.
From: A.G. IJntema Sent: Thursday, October 14, 2010 10:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - re: conditional var listview background color Aother option, instead of using colors is to make the blob visible or not. Syntax is: PROPERTY <Component ID> VISIBLE 'TRUE' | 'FALSE' I myself find properties extremely powerful, because instead of programming all kind of checks and balances you simply can enable / disable functionality. It saves a lot of energy and as a good developer you must be lazy J! Tony From: [email protected] [mailto:[email protected]] On Behalf Of Luc Delcoigne Sent: donderdag 14 oktober 2010 21:58 To: RBASE-L Mailing List Subject: [RBASE-L] - re: conditional var listview background color Hi Tony, thanks. But the form I'm talking of is only to browse not to enter data. So I suppose it wouldn't work.... Luc D. From: A.G. IJntema Sent: Thursday, October 14, 2010 9:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - re: conditional var listview background color 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 Lustig Sent: Thursday, October 14, 2010 8:24 PM To: RBASE-L Mailing List 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
