Hello all,
I am writing a tcl script with sqlite commands. I have a tcl list having
many members. I want to pass this list and make each list member as column
name in sqlite table.
List :$column_id
using db eval {CREATE TABLE t1 (step)}
foreach i $column_id{
db eval {ALTER TABLE t1 ADD COLUMN $i}
}
error message :
duplicate column name: $i
while executing
"db eval {ALTER TABLE flow_table ADD COLUMN "$i"}"
("foreach" body line 2)
invoked from within
"foreach i $column_id { puts "$j. $i\n"
db eval {ALTER TABLE flow_table ADD COLUMN "$i"}
incr j}"
Please reply as soon as possible with a solution.
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Problem-in-substituting-tcl-variable-in-sqlite-tp74497.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
