Is it possible to use back/fill colours in table view?
I have not managed to do so.

I want to display fields according to their value in different colours (green, yellow, red) indicating the availability status.
There are about 35 records with each 4 values.

-Carsten

i seem to recall that perhaps Version 2 would have more tools for TableView, will these be among those new features?

I'm looking into a means to do this (and much else). The problem with implementing something like this in a table is that the only place to store the color value is either with the column (which is the same as storing it with the LE), or with each individual cell. Currently we store this with all of the other 50 some LE settings with the column. Storing it with each cell would be very memory consumptive. Imaging you had 10,000 records and each had 150 LEs - to store an RGB value (3 bytes) would occupy 4,500,000 bytes.

The alternative which I am exploring is to implement a new SBasic programming event "On Draw". This SBasic would get called just before the element is drawn on the screen. This would allow the programmer to change LE settings (like color) for that cell just before it is drawn based on the value in that cell. This would allow exceptions to the LE (column) color for one or more elements in the column wthout having to store parameters for each and every cell.

This would have the added benefit of being applicable to all LEs - not just table cells and could be applied generically and uniformally across the entire form. The primary question is whether the overhead of calling SBasic code while the screen is redrawing would be distracting to the user (cause flicker) . The SBasic programmer would also have to be careful that their code does not cause endless redraw interation.

In any case, I'll give it a try and see.

Mark,

I am currently using SBasic programming on the form to colour cells depending on their value (available, not sure, not available). I do this on form entry. This obviously gives my only the status for one record but I would like to see it for a set of records (this is a travel booking DB and I want to signal room availability for several weeks in a hotel).

I see you point with storing the values and apreciate it the more as I am running the application as client/server on the network.
As I am interested in a snapshot of the values I would not rquire them to be updated and could accept a short waiting period on form/table entry. I would also be satisfied to do this on a report basis.

regards
Carsten

Karl,

Thanks for the hint. I had this in mind as well but unfortunately I do not have text/numbers in all of the fields as some actual values are supposed to be hidden and only a status shall be given.

It looks as though I will have to wait for 2.0

regards
Carsten

I do not want to show values in all of the fields, but a background colour depending on the value.

Example:
I have a hotel with single, double, 3-bed, and 4-bed rooms. For the singles I give the actual number of available rooms whilst for the rest I only give colours, say red for 0 or 1 room, yellow between 2 and 5 and green for more than 5.

Bob_Hansen wrote on Jul 20^th, 2006 at 8:01pm:


While not strictly a TableView feature, I have added a new programming event: "On Draw". Programming can be placed in the "On Draw" event to, for example, change the color of a table cell based on that cell's value.

Mark,

Want it, want it! 

This will certainly be solving my problem. Any idea when 2.0 is available?

Thanks
Carsten