'Re: [Kexi] SQL Queries in Kexi'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: kexi
Subject: Re: [Kexi] SQL Queries in Kexi
From: "Ken Hess" <kenneth.hess () gmail ! com>
Date: 2008-01-31 15:15:00
Message-ID: e8bfc0dd0801310715i6617bb1ev29053d6b145cf648 () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

[Attachment #4 (text/plain)]

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

-- 
Kenneth Hess
(918) 665.8878
http://www.kenhess.com

[Attachment #5 (text/html)]

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&gt; CLI. <div>On 1/31/08, Jarosław Staniek \
&lt;<a href="mailto:js@iidea.pl">js@iidea.pl</a>&gt; wrote: <blockquote \
class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: \
#ccc 1px solid">Ken Hess said the following, On 2008-01-31 15:47: &gt; How do you \
execute SQL queries in Kexi? I see how to enter them and check &gt; them for \
accuracy but there isn&#39;t any where to execute them. &gt; This kind of thing \
should be standard,...like using INSERT for multi record &gt; insertion or regular \
queries. Use &quot;Switch to data view mode&quot; toggle button. There are \
currently no so-called &quot;functional&quot; 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 (<a \
href="http://www.openoffice.com.pl/en">http://www.openoffice.com.pl/en</a>) to work \
on Kexi &amp; KOffice (<a href="http://www.kexi.pl/en">http://www.kexi.pl/en</a>, \
<a href="http://www.koffice.org/kexi">http://www.koffice.org/kexi</a>) KDE \
Libraries for MS Windows (<a \
href="http://windows.kde.org">http://windows.kde.org</a>) _______________________________________________ Kexi \
mailing list <a href="mailto:Kexi@kde.org">Kexi@kde.org</a> <a \
href="https://mail.kde.org/mailman/listinfo/kexi">https://mail.kde.org/mailman/listinfo/kexi</a> 
 </blockquote></div> -- Kenneth Hess (918) \
665.8878 <a href="http://www.kenhess.com">http://www.kenhess.com</a>

_______________________________________________
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi

[prev in list] [next in list] [prev in thread] [next in thread] 