On 23 Feb 2013, at 12:54pm, Paul Sanderson <[email protected]> wrote:
> Hmm works OK at an sqlite prompt but not when I pass the query though a > data access component The sqlite shell tool formats output for you, formatting to make the column layout look good and adding headers according to how you have it set. The SQLite API just returns the raw data you requested and it's up to the software to do formatting and layout. If you're using a data access component then you're obviously doing programming, so you can write your own code to calculate totals and add whatever headers you want. Sooner or later you're going to have to do some programming, it might as well be now. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
