Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Le 29/07/13 10:00, Heinrich Stoellinger a écrit :

Hi Heinrich,

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
 (select 999,a2.persNr,anwesend,statAnw,abwGrund,a2.mitfahrer,bemerkung
  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
the script.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.