BorlandTalk.com

Adrian Pitulac · Guest

Hello,

I'm trying to change some cell values for a TableDataSet at loading time. I
want to change some specific date values "1970/01/01" into a text like "N/A"
or to leave that table cell empty. I have tried to work with DBCellRenderer
but i got some "cannot resolve symbol " errors.... pointing to
JdbTable.DBCellRenderer class...

Please help me with some advices.. or any other way of dealing with my
problem it's very URGENT... Is there any other way of solving my problem
else then that with JdbTable.DBCellRenderer?

This is the example from the Jbuilder Manuals:

import java.awt.*;
import javax.swing.*;
import com.borland.dbswing.*;

public class NegativeNumberRenderer extends JdbTable.DBCellRenderer {

public NegativeNumberRenderer(JdbTable jdbTable) {
jdbTable.super();
}
public Component getTableCellRendererComponent(JTable table, Object
value,
boolean isSelected, boolean hasFocus, int row, int column) {
super.getTableCellRendererComponent(table,value, isSelected, hasFocus,
row, column);
if (value != null) {
try {
// Compare numeric value of string to zero. This assumes that a
negative
// value has a leading minus sign, so only handles simple numeric
formats
if (Double.parseDouble((String) value) < 0.0d)
super.setForeground(Color.red);
}
// Use the default foreground if we can't get a number from the
string
catch (NumberFormatException nfe) {
}
}
return this;
}
}

Thanks....

Steve Burling · Guest

In article <417da6f4$1 (AT) newsgroups (DOT) borland.com>,
"Adrian Pitulac" <apitulac (AT) pcnet (DOT) ro> wrote:

David Sykes · Guest

We have successfully implemented a custom cell renderer for use in a
JdbTable. It looks something like this:

class MyRenderer extends TableFastStringRenderer {
public Component getTableCellRendererComponent(JTable table,
Object value,
boolean isSelected,
boolean hasFocus,
int row,
int column) {
Component renderer =
super.getTableCellRendererComponent(table,value,isSelected,hasFocus,row,colu
mn);
JdbTable dbTable = (JdbTable) table;
if (dbTable.getDataSet().getString("STATUS").equals("invalid")) {
setBackground(Color.red);
}
else if (dbTable.getDataSet().isNull("DATE_FIELD")) {
setValue("N/A");
}
else if (dbTable.getDataSet().getString("IS_URGENT").equals("yes")) {
setFont(myItalicFont);
}
}
}

*NOTE: we only change the background colour in our renderer, but I am
confident that the font and value changes would also work as I have shown
here.

The TableFastStringRenderer is the default class used for rendering cells in
JdbTables. At least it was in earlier versions of JBuilder. I have not
checked this in JB2005, but our custom renderer works unchanged.

To install the custom renderer, we subclass JdbTable, and override the
(protected) getDefaultCellRenderer() method to return an instance of the
custom renderer. As follows:

class MyDbTable extends JdbTable {
protected TableCellRenderer getDefaultCellRenderer(Column dataSetColumn) {
if (one of the columns I want the custom renderer for) {
return new MyRenderer();
}
else {
return super.getDefaultCellRenderer(dataSetColumn);
}
}
}

There is probably another way to install the custom renderer for your
columns, but the way I have shown here works for us.

Hope this helps you,
David Sykes

"Steve Burling" <srb (AT) umich (DOT) edu> wrote

Adrian Pitulac · Guest

Sure. No answer till now. Anyway i have managed after some time to find a
solution:

static class Painter implements ColumnPaintListener {

public Painter() { super();}

public void editing(DataSet dataSet, Column column, CustomPaintSite
paintSite){}

public void painting(DataSet dataSet, Column column, int row, Variant
value, CustomPaintSite paintSite){

if(value.getDate().toString().matches("1970-01-01")){value.setDate(null);}
}
}

And in the initialization code (jbInit() usually) put:

Column col_15 = jdbTable1.getDataSet().getColumn(15);
col_15.addColumnPaintListener(new Painter());

This should do it. I think that this is a easier way of doing the "job" than
the way David Sykes showed you. I have tried also that solution but it
seemed to me that it was a little harder to implement.

If you need any other help tell me and i'll gladly help you.

Adrian

"Steve Burling" <srb (AT) umich (DOT) edu> wrote