db1 eval {INSERT INTO t1 VALUES(1,'hello')} db1 eval {INSERT INTO t1 VALUES(2,'goodbye')} db1 eval {INSERT INTO t1 VALUES(3,'howdy!')} set x [db1 eval {SELECT * FROM t1}]
Now i get a flat list:
1 hello 2 goodbye 3 howdy!
but i would prefer to have
set x [db1 evallist {SELECT * FROM t1}]
{1 hello} {2 goodbye} {3 howdy!}
They way I used so far seems not to be the fastest (especially for larger data sets):
set _res_ {} db eval {SELECT * FROM t1} _values_ { set _tmp_ {} foreach _part_ $_values_(*) { lappend _tmp_ $_values_(${_part_}) } lappend _res_ ${_tmp_} }
TIA
Stefan