[sqlite] using tcl/tk and sqlite

[Peter Berkel]

Hallo,

I am not an expert in programming and I try make a frontend 
for sqlite using tcl/tk. See example code below. 

I have the following problem. I try to entry data which I want to insert in a 
sqlite database. The Values of the textvariables a b and c in the entry widget 
are set in the insert statement. 

What do I wrong and how can I solve the problem so that I can use the entry 
widget to insert, modify and delete dat from a sqlite database.

Thanks for helping me out.

Peter Berkel


load tclsqlite3 sqlite3
  sqlite3 db test.db
  db eval {
    CREATE TABLE t1(a,b,c);
    }
  
set a  0
set b  0
set c  0


entry .entry1 -width 20 -textvariable a 
entry .entry2 -width 20 -textvariable b
entry .entry3 -width 20 -textvariable c


db eval {insert into t1 values ($a,$b,$c)}

button .button1 -text "execute"

pack .entry1 .entry2 .entry3 .button1 

db close