Le 29/07/13 10:00, Heinrich Stoellinger a écrit :
Using the German UI, I don't have a "Tools" menu item. I suspect it is
"Extras" in my version. Clicking on "SQL" under THAT menu I can enter the
SQL statement alright. As mentioned before, this statement is
Yes, that's right, sorry, I don't switch my UI to German very often.
insert into anwesenheit
from anwesenheit a2
where a2.veranstNr = 796);
(also tried without the ";")
On execution I still get back the same error!
Unfortunately, not all statements that you can run from the command line
in MySQL's SQL dialect will work, even via the Tools/Extras - SQL menu
You should try and make your SQL statement more standards SQL compliant,
the baseline for LO being ANSI SQL 1999, I think (but don't quote me on it).
Ultimately, you will probably have to try and reformulate your statement
in a way that LO understands, however, this may, or may not actually be
possible, at least not in the way in you want.
As a long-time systems "nurd" I myself don't mind entering the statement
from a mysql-client command-line. It is just that handing the
of the database over to "normal" people, I cannot expect them to use a text
editor to define the query that way and then run it through the mysql
Agreed, but I'm afraid that LO still lacks the desired feature set for that.
SQL queries should be able to cover statements as the one above. I use it
to keep a table up-to-date which shows the presence of musicians in my band
at practices every week or concerts...
phpMyAdmin isn't really an alternative either...
Agreed. Currently, the best way to achieve what you are looking for, if
a SQL INSERT SELECT statement is not accepted, is to use Basic, or
another programming language that interfaces with LO to produce what you
want and the use form elements to associate that with the execution of
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy