nevergiveup01
Programmer
Hi, I'm trying to create a trigger that inserts a new record into tblService with the QuoteID from tblServiceQuote when tblServiceQuote.Accepted = true or = 1( it's a bit).. Anyway, I'm struggling and I'm wondering if someone can tell me where I'm going wrong..
CREATE TRIGGER servicequote
AFTER update servicequote
When(ServiceQuote.Accepted=1)
BEGIN
-- Insert record into Service table
INSERT INTO service
( ServiceQuote.quoteid
)
VALUES
( : quoteid,
);
END;
CREATE TRIGGER servicequote
AFTER update servicequote
When(ServiceQuote.Accepted=1)
BEGIN
-- Insert record into Service table
INSERT INTO service
( ServiceQuote.quoteid
)
VALUES
( : quoteid,
);
END;