Using SQLite with Tcl - Querying

Page 13 of 41
[prev] [next]

Use an array variable name in between the SQL statement and the Tcl script to cause values to be loaded into an array

  db eval {SELECT a AS x, b AS y, c AS z FROM t1} abc {
     parray abc
  }


  abc(*) = x y z
  abc(x) = 1
  abc(y) = 2
  abc(z) = 3
  abc(*) = x y z
  abc(x) = hello
  abc(y) = 
  abc(z) = world

The special (*) element of the array holds a list of all columns in column order