Thanks, this runs OK now. I am not familiar with JSON, but was just trying this out and see if I could make it work in SQLite.
RBS On Mon, Sep 4, 2017 at 8:40 AM, Rowan Worth <row...@dug.com> wrote: > On 4 September 2017 at 15:37, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > > > Trying this out, so I edited the source and indeed now there is no crash. > > I get however a message: > > > > malformed JSON > > > > This is the dump of that testing table, dataset: > > > > doc > > {"field1": [{"value": "val1"}, {"value": "val2"}] > > {"field1": [{"value": "val3"}, {"value": "val2"}] > > {"field1": [{"value": "val4"}, {"value": "val1"}] > > > > Is there anything wrong with this JSON data? > > > > Yes, it's malformed. > > > ... :P > Specifically, there's no closing curly brace for the top-level object. > > {"field1": > [ > {"value": "val1"}, > {"value": "val2"} > ] > *** MISSING CURLY BRACE HERE *** > > -Rowan > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users