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.<br><br>
<div><span class="gmail_quote">On 1/31/08, <b class="gmail_sendername">Jarosław Staniek</b> <<a href="mailto:js@iidea.pl">js@iidea.pl</a>> wrote:</span>
<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:<br>> How do you execute SQL queries in Kexi? I see how to enter them and check<br>
> them for accuracy but there isn't any where to execute them.<br>> This kind of thing should be standard,...like using INSERT for multi record<br>> insertion or regular queries.<br><br>Use "Switch to data view mode" toggle button.<br>
There are currently no so-called "functional" queries supported in Kexi<br>(parser currently supporting SELECTs will have to support INSERTs, UPDATEs as<br>well, and ideally, the GUI will have to somewhat display preview of the results).<br>
<br>So you should use external tools like the ksqlite console.<br><br>It is safer to close the Kexi file or at least the table (of form) before<br>running SQL commands that modify already opened and loaded data.<br><br>--<br>
regards / pozdrawiam, Jaroslaw Staniek<br>Sponsored by OpenOffice Polska (<a href="http://www.openoffice.com.pl/en">http://www.openoffice.com.pl/en</a>) to work on<br>Kexi & 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>)<br>
KDE Libraries for MS Windows (<a href="http://windows.kde.org">http://windows.kde.org</a>)<br>_______________________________________________<br>Kexi mailing list<br><a href="mailto:Kexi@kde.org">Kexi@kde.org</a><br><a href="https://mail.kde.org/mailman/listinfo/kexi">https://mail.kde.org/mailman/listinfo/kexi</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Kenneth Hess<br>(918) 665.8878<br><a href="http://www.kenhess.com">http://www.kenhess.com</a>