Author |
Messages |
jr{@}mpv.com
Unregistered
|
Posted Wednesday, December 31, 1969 @ 23:59:59
Hi, I would like to remove rows from the DBTable without deleting them from the database. Something like DBTable.delete(false) that would remove the selected rows from the view but would leave the database alone. With JTable I can use the SelectionModel and a custom TableModel that implements a deleteRow() method. Is this possible with DBTable? Does DBTable use the default JTable TableModel?
|
admin{@}quicktable.org
Unregistered
|
Posted Wednesday, December 31, 1969 @ 23:59:59
As long you don't set the Delete Sql using the addDeleteSql method, the records won't be deleted from the database, when the user deletes the record or when you call delete() or delete(int[]) methods. The tablemodel is internaly handled for you, don't worry about the table model.Ben
|
jr{@}mpv.com
Unregistered
|
Posted Wednesday, December 31, 1969 @ 23:59:59
Ben, thanks! I did try DBTable.delete() without the delete SQL set but DBTable shows blank rows in place of the original row. It look awful and does not limit how many rows the user see. Is it possible to make the blank rows disappear?
|
admin{@}quicktable.org
Unregistered
|
Posted Wednesday, December 31, 1969 @ 23:59:59
I have fixed the bug in delete. Please download the latest free quicktable download file. let me know if this works now.
|
jr{@}mpv.com
Unregistered
|
Posted Wednesday, December 31, 1969 @ 23:59:59
I downloaded the latest version 2.0.2 and tried my app but I continue to see blank rows inplace of the deleted rows. I have debug on, below is the output.QuickTable 2.0.2 (Free Version). Buy at http://quicktable.org deleteSql not set for DBTable, so this record is not deleted in database
|
admin{@}quicktable.org
Unregistered
|
Posted Wednesday, December 31, 1969 @ 23:59:59
I think you still have the old version. the new version number is 2.0.3. Please clear your cache & try
|
jr{@}mpv.com
Unregistered
|
Posted Wednesday, December 31, 1969 @ 23:59:59
Works fine after I corrected my classpath to point to 2.0.3. Thanks Ben.J.R.
|