2017-11-16 18:44 GMT+01:00 Peter Da Silva <[email protected]>:
> > On 11/16/17, 11:37 AM, "sqlite-users on behalf of Cecil Westerhof" < > [email protected] on behalf of > [email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
