On Fri, Mar 28, 2014 at 8:39 AM, Bertini, Denis Dr. <[email protected]>wrote:
> 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'm not sure what "the SQLite C driver" is.
Run this test please: Evaluate the following using "SQLite C driver":
SELECT sqlite_version(), sqlite_source_id();
Then let us know what the results are. Thanks.
> 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
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
