[Kexi] SQL Queries in Kexi
kenneth.hess at gmail.com
Thu Jan 31 16:15:00 CET 2008
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 <js at iidea.pl> 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
> > them for accuracy but there isn't any where to execute them.
> > This kind of thing should be standard,...like using INSERT for multi
> > 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
> well, and ideally, the GUI will have to somewhat display preview of the
> 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
> Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
> KDE Libraries for MS Windows (http://windows.kde.org)
> Kexi mailing list
> Kexi at kde.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Kexi