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