Re: [sqlite] Strange execution times

Ulrich, all improvements in knowledge start with curiosity, our most precious asset. JS Ulrich Schöbel wrote: Hi John, there isn't really much to remove, but nevertheless I followed your advice and replaced the sqlite select by a small standard tcl procedure. Maybe that set me on the right

Re: [sqlite] alter table syntax ?

"Doug Fajardo" <[EMAIL PROTECTED]> wrote: > Help! > I keep getting a syntax error from the 'alter table' sql command, when > used to add a column to a table. Can someone help with this error? Below > is an example of one attempt, and its results: > > [tuna]$ sqlite test2.db > SQLite version

[sqlite] alter table syntax ?

Help! I keep getting a syntax error from the 'alter table' sql command, when used to add a column to a table. Can someone help with this error? Below is an example of one attempt, and its results: [tuna]$ sqlite test2.db SQLite version 2.8.16 Enter ".help" for instructions sqlite> create table x1

Re: [sqlite] Trigger and Tree Problem

Not sure if there's a way with your current code, but if you use either an LTREE or nested sets you'd be able to detect this situation quite easily. There was a discussion about both on the list about 2 weeks ago. On Thu, Feb 23, 2006 at 05:13:37PM +0100, Thorsten Kortmann wrote: > sorry for my

[sqlite] Trigger and Tree Problem

sorry for my english.. i have two tables: 1. GROUP id description is_subgroup 2. GROUPDETAIL id groups_id remote_id remote_type - each group can have 1 to x groupdetail. - groupdetail.remote_type can have two values, 0 and 1 if it is 0, remote_id points to a product