https://bugs.documentfoundation.org/show_bug.cgi?id=124069
--- Comment #3 from Drew Jensen <drewjensen.in...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs