Hi Alex,
Using the German UI, I don't have a Tools menu item. I suspect it is called
Extras in my version. Clicking on SQL under THAT menu I can enter the
SQL statement alright. As mentioned before, this statement is
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!
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 administration
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 client.
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...
Thanks for your help in any case
Regards
H
On Sun, 28 Jul 2013 20:08:52 +0200, Alexander Thurgood
alex.thurg...@gmail.com wrote:
Le 28/07/13 17:03, Heinrich Stoellinger a écrit :
Hi Heinrich,
I never tried it previously. How do I set the internal SQL parser off?
Regards
Sorry, I'm being a bit dim. INSERT statements can only be run from the
Tools SQL menu entry and not from the SQL Query window (or Designer
for that matter).
Alex
--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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
