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)
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
