[sqlite] Enabling recursive triggers

2006-10-05 Thread George Herson
1 set updcnt=updcnt+1; end sqlite> select * from t1; 1|a|2 sqlite> update t1 set intcol=1; Segmentation fault Advice on how to pursue enabling recursion? My C is rusty. I prefer Linux but also run Windows. TIA, George Herson <1>http://marc.theaimsgroup.com/?l=sqlite-users=2=1=recurs

Re: [sqlite] table persistance (newbie)

2006-10-01 Thread George Herson
warning, readers: the below is boring. I'm just following up. --- Rich Shepard <[EMAIL PROTECTED]> wrote: > On Sun, 1 Oct 2006, George Herson wrote: > > > It seems to me that > http://www.sqlite.org/lang_createtable.html should > > mention the ramifications of not p

Re: [sqlite] table persistance (newbie)

2006-10-01 Thread George Herson
Thanks for the info, Rich Shepard and Jan Kandziora. 3 documention-related suggestions about this: It seems to me that http://www.sqlite.org/lang_createtable.html should mention the ramifications of not passing in a database name when using the sqlite3 executable. the executable should confirm

[sqlite] table persistance (newbie)

2006-10-01 Thread George Herson
I downloaded sqlite3.exe (as sqlite-3_3_7.zip) today onto WinXP Home, created a couple (non-temp) tiny test tables with it, entered .exit, ran sqlite3.exe once again, and found that those oh-so-promising electric charges had apparently been unintentionally bequeathed to the bit bucket. I.e., I