Re: [sqlite] tcl incrblob interface

2011-08-12 Thread Victor Mayevski
Thanks Richard, this is very useful. On Wed, Aug 10, 2011 at 9:46 AM, Richard Hipp d...@sqlite.org wrote: On Wed, Aug 10, 2011 at 12:24 PM, Victor Mayevski vit...@gmail.com wrote: Hello, I am trying to learn how to use the incrblob command in the Tcl interface and I can't get it to work

Re: [sqlite] tcl incrblob interface

2011-08-12 Thread Victor Mayevski
That's exactly what it was. Thanks On Wed, Aug 10, 2011 at 11:37 PM, Dan Kennedy danielk1...@gmail.com 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 get it to work. I create a one column

[sqlite] tcl incrblob interface

2011-08-10 Thread Victor Mayevski
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 world,

[sqlite] possible bug foreign key mismatch in TCL

2011-07-12 Thread Victor Mayevski
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

[sqlite] triggers revisited

2009-11-03 Thread Victor Mayevski
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