Hmm works OK at an sqlite prompt but not when I pass the query though a data access component
On 23 February 2013 11:05, Clemens Ladisch <[email protected]> wrote: > Paul Sanderson wrote: > > Works well summing the columns but I don't get a 'tot' label I, get > > > > 1 54 3 > > 2 26 4 > > 3 56 8 > > 0 136 15 > > Works for me. > > Your example data and your query don't match (three vs. four columns). > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

