Re: Need Help with TRIGGER and IF

[Peter Brawley]

The one-word answer is: normalise!

Column names test1...test15 strongly suggest a table design problem. That is, if instead of (id int primary key, test1 char(16),... test15 char(16) ), you had ...

overall(oid int primary key, name char...)
tests(
  tid int primary key, 
  oid int, foreign key(oid) references overall(oid),
  result char(16))
)

then a simple sql command ...

update tests set result='fail' where ord=so-and-so;

would accomplish your task.