Re: [sqlite] SQLite & TCL: A "SELECT" from one-column table

2008-05-03 Thread Zbigniew Baniewski
On Sat, May 03, 2008 at 03:07:00PM -0400, D. Richard Hipp wrote: > > dbcomm eval {CREATE TABLE something( a_string VARCHAR(20) )} > > dbcomm eval {INSERT INTO something VALUES ('Version V8.5')} > > > > Now, if you want to retrieve the value: > > > > tclsh8.5 [~/tmp/tcltk]dbcomm eval "SELECT a_st

Re: [sqlite] SQLite & TCL: A "SELECT" from one-column table

2008-05-03 Thread Zbigniew Baniewski
On Sat, May 03, 2008 at 09:52:06PM +0200, Zbigniew Baniewski wrote: > False alarm; sorry. A database has been improperly restored from ASCII dump. Cannot reproduce. :( Restored it - before, and now - quite common way: sqlite3 dbase.db http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-us

Re: [sqlite] SQLite & TCL: A "SELECT" from one-column table

2008-05-03 Thread Zbigniew Baniewski
On Sat, May 03, 2008 at 03:07:00PM -0400, D. Richard Hipp wrote: > > Why so much parentheses? A list, nested in a list, nested in a list? > > But why? > > I get just {Version V8.5} when I try this. False alarm; sorry. A database has been improperly restored from ASCII dump. --

Re: [sqlite] SQLite & TCL: A "SELECT" from one-column table

2008-05-03 Thread D. Richard Hipp
On May 3, 2008, at 1:52 PM, Zbigniew Baniewski wrote: > Take a look at following example: > > dbcomm eval {CREATE TABLE something( a_string VARCHAR(20) )} > dbcomm eval {INSERT INTO something VALUES ('Version V8.5')} > > Now, if you want to retrieve the value: > > tclsh8.5 [~/tmp/tcltk]dbcomm e

[sqlite] SQLite & TCL: A "SELECT" from one-column table

2008-05-03 Thread Zbigniew Baniewski
Take a look at following example: dbcomm eval {CREATE TABLE something( a_string VARCHAR(20) )} dbcomm eval {INSERT INTO something VALUES ('Version V8.5')} Now, if you want to retrieve the value: tclsh8.5 [~/tmp/tcltk]dbcomm eval "SELECT a_string FROM something" Version V8.5 Why so m