craftleft.gif (3002 bytes)QuickTable
Home | API | Tutorial | Download | Support | Contact topblack.gif (108 bytes)


QuickTable User Cp  |  Register  |  Members  |  Search  |  Help
    |- QuickTable Discussion Forums > JDBC/Database Issues Post New Topic   Post A Reply
Remove w/o deleting from DBTable printer friendly version
next newest post | next oldest post
Author Messages
jr{@}mpv.com
Unregistered
Edit or delete this message Reply w/Quote
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
Edit or delete this message Reply w/Quote
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
Edit or delete this message Reply w/Quote
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
Edit or delete this message Reply w/Quote
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
Edit or delete this message Reply w/Quote
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
Edit or delete this message Reply w/Quote
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
Edit or delete this message Reply w/Quote
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.

Post New Topic   Post A Reply Jump to:
Contact Us | QuickTable - A Java DBGrid | Privacy Policy All times are GMT -5 Hours.
Welcome to QuickTable Forums, Guest!  
Login
Username :
Password :
In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!
Powered by CuteCast v2.0 BETA 2
Copyright © 2001-2003 ArtsCore Studios