Hi,

The trigger below does not seem to work?

I have 2 tables:
ecastdata
ecastbounces

When the 'ecastdata' table gets updated with certain criteria I want those records to be copyed into the 'ecastbounces' table.
For some reason the trigger does not work?

I think it might be going wrong with this bit of code?:
(Select max(ecastdata.EcastID) from ecastdata) AND BounceHard > 0


------Trigger--------------

CREATE TRIGGER InsBouncesTR
ON ecastdata

FOR UPDATE

AS

INSERT INTO ecastbounces (ID, EcastID, Email)
SELECT Email FROM ecastdata WHERE EcastID = (Select max(ecastdata.EcastID) from ecastdata) AND BounceHard > 0

----------------------------

Any Ideas

PLEASE HELP!

HMan,

The number of columns in INSERT INTO statement do not match your SELECT. You are insterting into 3 columns but only selecting 1:

INSERT INTO ecastbounces (ID, EcastID, Email)
SELECT Email FROM...

The number of columns must be equal. For example:

INSERT INTO ecastbounces (ID, EcastID, Email)
SELECT Email, column2, column3 FROM...

Scott

Thanks alot Scott.

It was my silly mistake, doh :)

No problem hman. Glad I could help.

Scott