Re: Help with isql - Moving results from Detail to Master table

} Hi Richard, } } OK - I give up when does procedure zzz get executed? } } Too many 4 packs recently? } } Cheers, } Peter } } >create trigger xxx } >insert on review } >referencing new as post } >for each row when (post.rev_status_code = "COMPLETE" or post.rev_status_code = } >"CANCEL") (execute procedure yyy(post.rev_date_completed, post.rev_status_code); } ^^^^^ Well spotted Peter! No 4 packs till tonight - got paid today, yippee :-) Of course it should say "execute procedure zzz" (or "create procedure yyy" !) } > } >create procedure zzz(rev_date date, status char(10)) } > } > insert into report (rep_date_completed, rep_status_code) values } >(rev_date, status); } > } >end procedure } >; }