Re: [GENERAL] trigger howto question

2007-01-16 Thread Richard Huxton
Furesz Peter wrote: Hello, I have a table named foobar and I don't want to allow from DELETE or UPDATE its rows. I have a table as described below: foobar(foobar_id, value, is_deleted); I don't want to allow directly delete or modify the table's rows. I plan to make an on before update or d

[GENERAL] trigger howto question

2007-01-16 Thread Furesz Peter
Hello, I have a table named foobar and I don't want to allow from DELETE or UPDATE its rows. I have a table as described below: foobar(foobar_id, value, is_deleted); I don't want to allow directly delete or modify the table's rows. I plan to make an on before update or delete trigger and on de