On 4 Oct 2017, at 4:06pm, Doug Nebeker <ad...@poweradmin.com> wrote:
> Is it just a matter of using sqlite3_create_function to register a function > that guarantees it will concatenate in the order rows are received? Would > that guarantee that your example works, or is order no longer guaranteed once > they leave the inner select? > > SELECT group_concat(LineText, '\n') FROM > (SELECT LineText FROM DocLines > WHERE DocID = 10 > ORDER BY LineIndex) I’ve never tried it but I can’t think why it wouldn’t work. Yes, you could register a function written in your favourite shimmed language. All this really does is move the "concat_in_order" function from your own code into SQLite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users