using TCL with sqlite database...

Hello all,

I'm trying to access an SQLite database via TCL.
Creating/opening/create tables etc. succeeds when doing it in 1 procedure,
but fails when I open the db in proc open_sqlite_db {} and try to write
to it in proc write_sql_db {}

example code:

proc general_calling_procedure {} {
# sqlite library is already loaded...

open_sqlite_db
write_sqlite_db { "t_test" "some data" }
...
}

proc open_sqlite_db {} {
sqlite testdb "./my_example.db"
testdb eval { create table t_test ( dummy varchar(30) ) }
}

proc write_sqlite_db { table data } {
testdb eval { insert into $table values($data) }
}

####

If I read back the data which should have been written, there is
just nothing... Quite frustrating...
Most probably it has nothing to do with sqlite itself, just the way to
access the command 'testdb'.
That's the reason why I first try it here...

Kind regards,

Jan
.

Relevant Pages

  • Re: using TCL with sqlite database...
    ... I'm trying to access an SQLite database via TCL. ... Creating/opening/create tables etc. succeeds when doing it in 1 procedure, ... but fails when I open the db in proc open_sqlite_db and try to write ...
    (comp.lang.tcl)
  • Re: using TCL with sqlite database...
    ... should give you a syntax error, ... I'm trying to access an SQLite database via TCL. ... but fails when I open the db in proc open_sqlite_db and try to write ...
    (comp.lang.tcl)
  • Re: PROBLEM: pthread-safety bug in write(2) on Linux 2.6.x
    ... the pipe guarantees atomicity. ... Proc 0 read 8174 bytes ... As shown, linux completely fails. ... on a dual SMP system, ...
    (Linux-Kernel)
  • Re: A compile problem or a conceptual one
    ... > I moved a proc from one module to another and I cannot compile it anymore. ... It fails with the message "Undefined identifier ...
    (comp.lang.pascal.delphi.misc)
  • A compile problem or a conceptual one
    ... I moved a proc from one module to another and I cannot compile it anymore. ... It fails with the message "Undefined identifier Self" ...
    (comp.lang.pascal.delphi.misc)