Using SQLite with Tcl - Querying

Page 15 of 41
[prev] [next]

The onecolumn method returns the first column of the first row of the result.

  set a [db onecolumn {SELECT * FROM t1}]
  puts a=$a

a=1

  set a [db onecolumn {SELECT a FROM t1}]

  set a [lindex [db eval {SELECT a FROM t1 LIMIT 1}] 0]

  db eval {SELECT a FROM t1} break