Re: [sqlite] tcl incrblob interface

That's exactly what it was. Thanks On Wed, Aug 10, 2011 at 11:37 PM, Dan Kennedy wrote: > On 08/10/2011 11:24 PM, Victor Mayevski wrote: >> Hello, >> >> I am trying to learn how to use the "incrblob" command in the Tcl >> interface and I can't

Re: [sqlite] tcl incrblob interface

Thanks Richard, this is very useful. On Wed, Aug 10, 2011 at 9:46 AM, Richard Hipp wrote: > On Wed, Aug 10, 2011 at 12:24 PM, Victor Mayevski wrote: > >> Hello, >> >> I am trying to learn how to use the "incrblob" command in the Tcl >> interface an

[sqlite] tcl incrblob interface

Hello, I am trying to learn how to use the "incrblob" command in the Tcl interface and I can't get it to work. I create a one column table "t", insert one empty value into it, than do "db incrblob t a 1", which works fine, I get a file pointer back "incrblob_1". Then I do "puts incrblob_1 "hello w

[sqlite] possible bug "foreign key mismatch" in TCL

I am getting a "foreign key mismatch" in TCL in the following situation: #The system is Ubuntu 10.10 32bit, using ActiveState 8.6 32 bit TCL binaries % package require sqlite3 3.7.6.3 #Two example tables: create table users (name primary key unique, pass not null) create table users1 (name refer

[sqlite] triggers revisited

Ok, I will rephrase my question although it appears that the answer is has been already preconceived. I am writing an abstraction layer to Sqlite where tables, views, triggers etc are presented as XOTcl Classes/Objects. If two different scripts access the database and one of them creates a new tabl

[sqlite] tirgger everywhere and always

Is it possible to implement triggers that fire up for each independent session? For example, I am using TCL, define a function in TCL, register it with SQLite, create a trigger to call that function every time an update happens to some table. Well, it works just fine for that specific open session.