<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird SQL: INSERT INTO...SELECT" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124069#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird SQL: INSERT INTO...SELECT" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124069">bug 124069</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>(In reply to Robert Großkopf from <a href="show_bug.cgi?id=124069#c6">comment #6</a>) > (In reply to Alex Thurgood from <a href="show_bug.cgi?id=124069#c4">comment #4</a>) > > > > 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). > > Don't agree. When queries in Tools > SQL will work without double-quotes > INSERTS and UPDATES should do it the same way. > > SELECT * FROM t2 > > will work. t2 will be accepted in a query. > > INSERT INTO t2 ... > > won't work. t2 won't be accepted in INSERTS, also won't be accepted in > UPDATES. Ok, so agreeing that it is not a valid statement in query definer, then what we have is identical behavior in the SQL Window and a Basic macro (API) currently. Saying after just now trying your examples in that macro with same results. Your point that the rules for quoting are different between select statements and other DML (update,insert) could be an error however, or maybe a RFE?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>