I just wanted to start using SQLite with TCL. How can I give a formatted
output?
When I use:
puts [db eval {SELECT * FROM teaInStock}]
I get:
Brandnetel {} 2017-11-16 1 Oolong {} 2017-10-29 2 Goudsbloem {} 2017-10-22
3 Jasmijn …
When I use:
db eval {SELECT * FROM teaInStock} {
puts $Tea
}
I get:
Brandnetel
Oolong
Goudsbloem
Jasmijn
…
When I use:
db eval {SELECT * FROM teaInStock} {
puts $Tea, $Location
}
I get:
can not find channel named "Brandnetel,"
while executing
"puts $Tea, $Location"
invoked from within
"db eval {SELECT * FROM teaInStock} {
puts $Tea, $Location
}"
I would like something like:
Brandnetel 2017-11-16 1
Oolong 2017-10-29 2
Goudsbloem 2017-10-22 3
Jasmijn …
And probably another complication: one of the columns is called: "Last
Used".
--
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
