Re: [GENERAL] How to prevent modifications in a tree of rows, based on a condition?

2007-06-19 Thread Kenneth Downs
Philippe Lang wrote: Hi, I have a database which can be simplified in the following way, with three tables: An "order" has multiple "order lines", and an "order line" has multiple "line steps". I'd like to prevent any kind of modification (insert, update, delete) in a order (and its lines, and

Re: [GENERAL] How to prevent modifications in a tree of rows, based on a condition?

2007-06-19 Thread A. Kretschmer
am Tue, dem 19.06.2007, um 12:23:51 +0200 mailte Philippe Lang folgendes: > > I'd like to prevent any kind of modification (insert, update, delete) in > a order (and its lines, and steps) if all the steps in the lines of the > order are "checked". If that condition is not true, a modification is

[GENERAL] How to prevent modifications in a tree of rows, based on a condition?

2007-06-19 Thread Philippe Lang
Hi, I have a database which can be simplified in the following way, with three tables: An "order" has multiple "order lines", and an "order line" has multiple "line steps". I'd like to prevent any kind of modification (insert, update, delete) in a order (and its lines, and steps) if all the step