Hi Alex,
This query (ommitting the "") has been working perfectly for years when issued
from the mysql
command-line client. It is correct SQL syntax...
Regards
H
On Thu, 25 Jul 2013 20:45:24 +0200, Alexander Thurgood
<alex.thurg...@gmail.com> wrote:
Le 25/07/13 18:54, Heinrich Stoellinger a écrit :
Hi Heinrich,
insert into "anwesenheit" "a1"
(select
795,"a2"."persNr","a2"."anwesend","a2"."statAnw","a2"."abwGrund","a2"."mitfahrer","a2"."bemerkung"
from "anwesenheit" "a2"
where "a2"."veranstNr" = 796)
http://www.hsqldb.org/doc/guide/ch09.html#insert-section
Don't you need to tell your db that you have VALUES to insert ?
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