Re: [GENERAL] Problem with UPDATE and UNIQUE

2007-08-23 Thread Michael Glaesemann
On Aug 23, 2007, at 8:59 , Frank Millman wrote: It certainly does. Thanks again for all the valuable advice. Glad you found it helpful. Good luck! Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 2: Don't 'kill -9' the po

Re: [GENERAL] Problem with UPDATE and UNIQUE

2007-08-23 Thread Frank Millman
Michael Glaesemann wrote: > > On Aug 22, 2007, at 1:02 , Frank Millman wrote: > > > I want to store data in a 'tree' form, with a fixed number > of levels, > > so that each level has a defined role. > Thanks very much for the in-depth response, Michael. Plenty for the little grey cells to wor

Re: [GENERAL] Problem with UPDATE and UNIQUE

2007-08-22 Thread Michael Glaesemann
On Aug 22, 2007, at 1:02 , Frank Millman wrote: I want to store data in a 'tree' form, with a fixed number of levels, so that each level has a defined role. First thought: fixed, predetermined levels, separate tables for each level. If a more general approach is desired, your options are

[GENERAL] Problem with UPDATE and UNIQUE

2007-08-21 Thread Frank Millman
Hi all I have a problem, which I suspect stems from bad design. If I explain what I am doing, perhaps someone can suggest a better approach. I want to store data in a 'tree' form, with a fixed number of levels, so that each level has a defined role. I have the following (simplified) table - CR