2017-11-16 18:44 GMT+01:00 Peter Da Silva <peter.dasi...@flightaware.com>:
> > On 11/16/17, 11:37 AM, "sqlite-users on behalf of Cecil Westerhof" < > sqlite-users-boun...@mailinglists.sqlite.org on behalf of > cldwester...@gmail.com> wrote: > > When I use: > > db eval {SELECT * FROM teaInStock} { > > puts $Tea, $Location > > } > > puts takes a single string, so you can do {puts “$Tea\t$Location”. > Arguments are separated by space, comma has no intrinsic meaning, and puts > takes two arguments: the file handle to write on and the string to print. > So it’s interpreting “$Tea,” as the name of a file handle. > > You probably want something like: > > db eval {SELECT * FROM teaInStock} { > puts [format “%12s %12s %s” $Tea ${Last Used} $Location] > } > This is what I use: puts [format "%-30s %-10s %2s" $Tea ${Last Used} $Location] Thanks. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users