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@iol.ie