[Libreoffice-bugs] [Bug 124069] Firebird SQL: INSERT INTO...SELECT

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124069

--- Comment #3 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Also the query works as expected when used in a macro:

Sub Main

stmt = thisdatabasedocument.currentcontroller.activeconnection.createStatement

stmt.execute( "INSERT INTO " + """t2""" + "(" + """accountchart""" +", "+
"""accountcode"""+") "+" SELECT "+ """accountchart""" +", "+"""accountcode"""
+" FROM "+ """t1""" )

End Sub

This runs as expected. 

So, the question really is; Should it run in the query definition window with
SQL Direct = True? 

I'm not sure but doesn't the query definition require a result set?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190314/00ae8885/attachment.html>