<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> <span class="fn">Alex Thurgood</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - Firebird SQL: INSERT INTO...SELECT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124069">bug 124069</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>WORKSFORME
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - Firebird SQL: INSERT INTO...SELECT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124069#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - Firebird SQL: INSERT INTO...SELECT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124069">bug 124069</a>
from <span class="vcard"><a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> <span class="fn">Alex Thurgood</span></a>
</span></b>
<pre>@Drew : No, it shouldn't run in the query window, or at least, the GUI query
interface isn't currently designed to accept INSERT statements (and never has
been). This part of the GUI is only designed to take select statements and
returne result sets, but not allow for updating or insertion.
We should close this as WFM, because the solution is to use DML statements with
quoting via the Tools > SQL window as you have indicated, and not the Query GUI
window (irrespective of whether it is executed directly or not).</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>