That works for SELECT but what about INSERT, etc? I tried an INSERT but it says the query is incorrect but it works in the sqlite> CLI.
On 1/31/08, Jarosław Staniek <[EMAIL PROTECTED]> wrote: > > 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 > -- Kenneth Hess (918) 665.8878 http://www.kenhess.com
_______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
