On 22/05/2014 13:48, Khangelani Gama wrote: > Hi > > My problem is on two lines, INSERT statements, I get an error saying c_cde > does not exist > > INSERT INTO center_changed SELECT c_cde, now(); - My problem is here: I > get an error saying c_cde does not exist, I cant how I can give You need to specify where c_cde is coming from - so OLD.c_cde or NEW.c_cde (or else SELECT .... FROM... if it's coming from somewhere else). Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx
