Actually I've just done it now, in SQLiteSpeed, and it allowed me to use double-quote as delimiter successfully.
Regards, Chris On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 9 Feb 2016, at 12:10pm, Chris Prakoso <chris at prakoso.net> wrote: > > > *insert into test (field1,field2) values (1,"two"),(2,"three")* > > As well as the comments about your software being out of date, you need to > know that the text delimiter in SQLite is the non-directional single quote > character normally seen as an apostrophe. You cannot successfully use the > double quote character or any directional quotes. > > Should be > > insert into test (field1,field2) values (1,'two'),(2,'three') > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >