John Jason Jordan said the following, On 2008-02-13 03:05: > Kexi 1.1.3 (KOffice 1.6.3) (Using KDE 3.5.8) on Ubuntu Gutsy x86_64 > > Back in the bad old MS Access days if I wanted to empty all records > from a table I did so with a query. I have spent the past hour poking > all over Kexi trying to figure out how to make a quick > click-click-click way to empty a table of all records. Is it with a > query? Do I have to learn SQL syntax to do so?
Hi Execute python script that runs a "DELETE FROM mytable" query on your database. Example scripts you can start with are available at http://www.kde-files.org/index.php?xcontentmode=617 and should be also bundled with your Kexi or Kexi scripting package. There is action like "Edit->clear table" but apaprently it is not provided for assigning to a form button in the "assign actions" dialog. -- regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi) KDE Libraries for MS Windows (http://windows.kde.org) _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
