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

Reply via email to