Hi all,
When using multiple rows insertion from the sqlite interpreter
for example something like :
sqlite>
INSERT INTO 'tablename' ('column1', 'column2') VALUES
('data1', 'data2'),
('data1', 'data2'),
('data1', 'data2'),
('data1', 'data2');
It works as it should for SQLite 3.7.11 and above.
But, when trying to execute the same command from the SQLIte C driver
i got an SQL syntax error statement , error near ",".
Apparently for the the same syntax can not be executed via the
sqlite3_exec() function.
To execute the SQL statement i use the std exec() function:
int ret =
sqlite3_exec(fSQLite<http://root.cern.ch/root/htmldoc/TSQLiteServer.html#TSQLiteServer:fSQLite>,
sql, NULL, NULL, &sqlite_err_msg)
Looking at http://www.sqlite.org/news.html
i could not find that the issue has already been fixed.
Can somebody tell me what am i doing wrong here?
Thanks in advance,
Dr Denis Bertini
IT - Scientific computing
GSI Helmholtzzentrum für Schwerionenforschung GmbH
Planckstraße 1
64291 Darmstadt
www.gsi.de<http://www.gsi.de>
Gesellschaft mit beschränkter Haftung
Sitz der Gesellschaft: Darmstadt
Handelsregister: Amtsgericht Darmstadt, HRB 1528
Geschäftsführung: Professor Dr. Dr. h.c. mult. Horst Stöcker,
Peter Hassenbach, Dr. Hartmut Eickhoff
Vorsitzende des Aufsichtsrates: Dr. Beatrix Vierkorn-Rudolph
Stellvertreter: Ministerialdirigent Dr. Rolf Bernhardt
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
