Hi,
SELECT sqlite_version();
> 3.8.2
SELECT sqlite_source_id();
> 2013-12-06 14:53:30 27392118af4c38c5203a04b8013e1afdb1cebd0d
Cheers,
Denis
Dr Denis Bertini
IT - Scientific computing
GSI Helmholtzzentrum für Schwerionenforschung GmbH
Planckstraße 1
64291 Darmstadt
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
On Mar 28, 2014, at 1:49 PM, Richard Hipp wrote:
> On Fri, Mar 28, 2014 at 8:39 AM, Bertini, Denis Dr. <d.bert...@gsi.de>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
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
