[GENERAL] Updating from a column

2010-01-18 Thread Bob Pawley
Hi I have a table that has one column (pump1) controlled by a dbcheckbox. The values can be True, False or null. I want to insert a row of values into second table when column pump1 value is 'True'. I don't want the trigger to insert a row when other columns of the first table are updated or

Re: [GENERAL] Updating from a column

2010-01-18 Thread Adrian Klaver
On Monday 18 January 2010 11:31:57 am Bob Pawley wrote: Hi I have a table that has one column (pump1) controlled by a dbcheckbox. The values can be True, False or null. I want to insert a row of values into second table when column pump1 value is 'True'. I don't want the trigger to insert a