When applying autofiler, all worked correctly.
Problems began with selecting an entry having string columns. I selected the entry MTM in the column BILANZ_METHODE and got following message:
03.03.2011 08:53:17 com.jidesoft.database.DatabaseTableModel refresh
SCHWERWIEGEND: Ungültiger Spaltenname 'MTM'.
With databasedebbuging it seems the following String has been sent to the database (you see the missing ').
DEBUG [AWT-EventQueue-0] - ==> Executing: select count(*) from QRY_STANDARD_DATENBASIS_ANSICHT_01 WHERE (BILANZ_METHODE_BWG=MTM)
03.03.2011 08:53:17 com.jidesoft.database.DatabaseTableModel refresh
SCHWERWIEGEND: Ungültiger Spaltenname 'MTM'.
When using a custom filter (with is in condition), following String has been sent to database:
select count(*) from QRY_STANDARD_DATENBASIS_ANSICHT_01 WHERE (BILANZ_METHODE_BWG IN ('MTM'))
All worked correct. I overwrite the methode
- Code: Select all
public Class<?> getColumnClass(int columnIndex)
and the returned classs is always a String.
Seems like a bug to me, or is it not possible to use a view instead of a table?
thx in advance for looking at this problem....