nick
Private

Gender: Male
Location: Greece
Registered: Apr 2007
Status: Offline
Posts: 4

---

Posted Sunday, April 15, 2007 @ 17:27:49  

Hello,
I have 7 columns from a database and they are ok. And i want to add a column "stock" to show the value col6- col7. The problem is that the
column "stock" is empty... I'm using the latest version and there are no exceptions. Here is the code:
Column stock=new Column(8,"Stock");
stock.setType(java.sql.Types.INTEGER);
dBTable1.addColumn(stock);
dBTable1.refresh();
stock.setPreferredWidth(40);
for(int i=0;i<dBTable1.getRowCount();i++ ){
java.math.BigDecimal ad= (BigDecimal) dBTable1.getValueAt(i, 5);
Integer a=ad.intValueExact();
java.math.BigDecimal ab=(java.math.BigDecimal) dBTable1.getValueAt(i, 6);
Integer b=ab.intValueExact();
Integer stockVal=a-b;
dBTable1.setValueAt(stockVal,i,7);//It doesn't seem to work
}
dBTable1.refresh();
this.add(dBTable1,"Center");

Thank you

[Edit by nick on Sunday, April 15, 2007 @ 19:58:51]

Admin
Board Owner

Gender: Unspecified
Location:
Registered: Jul 2003
Status: Offline
Posts: 9

---

Posted Tuesday, April 17, 2007 @ 05:25:54  

Please read carefully the API instructions for addColumn

Also read the following discussion
http://quicktable.org/discussion/cutecast/cutecast.pl?forum=11&thread=395

Also enable debug using dbtable.debug=true; this will show you all the debug messages.

In your code, I see that you call refresh() method after adding a column, which is not correct.