On 1/23/18, Rolf Ade <sql...@pointsman.de> wrote: > > While being able to use Tcl variable references inside db eval SQL > statements (as in > > set name "foo'bar" > db eval {SELECT * FROM sometable WHERE somecolumn = $name} > > ) this does work only for "simple" Tcl variable references.
That is correct. You can use an array variable, but the index part must be a constant. For example: set x(name) "whatever" db eval {SELECT * FROM tab WHERE col = $x(name)} As you observce, you cannot use another variable as the index to the array. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users