Here's my trigger code:
DELIMITER $$
DROP TRIGGER /*!50032 IF EXISTS */ `piecerate`.`spUpdate_Queue`$$
create trigger `piecerate`.`spUpdate_Queue` AFTER UPDATE on
`piecerate`.`queue`
for each row BEGIN
call spUpdateQueueCounts(new.iorderid);
insert into crap (iid,iorderid) values (new.iid,new.iorderid);
END;
$$
DELIMITER ;
To test, I do a simple update sql:
UPDATE queue SET ipriority = ipriority
But when I look in the CRAP table, there's still no records. I don't
get it...what's missing?
I'd also like to know if there's a way to step through and debug code like I can do in Visual FoxPro.
tia!
--Michael
DELIMITER $$
DROP TRIGGER /*!50032 IF EXISTS */ `piecerate`.`spUpdate_Queue`$$
create trigger `piecerate`.`spUpdate_Queue` AFTER UPDATE on
`piecerate`.`queue`
for each row BEGIN
call spUpdateQueueCounts(new.iorderid);
insert into crap (iid,iorderid) values (new.iid,new.iorderid);
END;
$$
DELIMITER ;
To test, I do a simple update sql:
UPDATE queue SET ipriority = ipriority
But when I look in the CRAP table, there's still no records. I don't
get it...what's missing?
I'd also like to know if there's a way to step through and debug code like I can do in Visual FoxPro.
tia!
--Michael