Ken Hess said the following, On 2008-01-31 15:47: > How do you execute SQL queries in Kexi? I see how to enter them and check > them for accuracy but there isn't any where to execute them. > This kind of thing should be standard,...like using INSERT for multi record > insertion or regular queries.
Use "Switch to data view mode" toggle button. There are currently no so-called "functional" queries supported in Kexi (parser currently supporting SELECTs will have to support INSERTs, UPDATEs as well, and ideally, the GUI will have to somewhat display preview of the results). So you should use external tools like the ksqlite console. It is safer to close the Kexi file or at least the table (of form) before running SQL commands that modify already opened and loaded data. -- 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
