On 23 Apr 2010, at 4:42pm, Derek Martin wrote: > It would be swell if sqlite3 had a -notruncate option or some such, > though adding one now wouldn't really solve my immediate problem, > since that wouldn't be available on our desktop image. With its > current behavior, column mode seems fairly worthless to me. I guess > I'll need to convince folks that HTML output is suitable, or that they > need to install some other database thingy to run this stuff. Using > sqlite3 for this seemed perfect, since it's already available to > everyone.
sqlite3 is meant more as a sort of programmer's admin utility than for use by non-programmers. And anyone who knows how to use sqlite3 should know how to use programs like awk which were designed explicitly to massage output formats in the way you describe. If you are intending to produce reports suitable for non-techies, you need to capture a programmer and bribe them with pizza to write software for you. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
