[Kexi] SQL Queries in Kexi

[Ken Hess]

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
> 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
> Kexi at kde.org
> https://mail.kde.org/mailman/listinfo/kexi
>



-- 
Kenneth Hess
(918) 665.8878
http://www.kenhess.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.kde.org/pipermail/kexi/attachments/20080131/08f69685/attachment.htm