Re: why the trigger is not working while refering other tables?

[Andrew Gilfrin]

"One of the most difficult things in writing the book was the fact that we were writing about things that were changing so quickly and dramatically. For instance, we'd write about triggers, and then two weeks later, functionality would change, and we'd rewrite... "

Yes I had much the same situation with my site, but working on a book it must be even more of a nightmare.

"Catch up or not, I'd rather be in a camp that respects and nourishes the creativity and requests of its developers... I'm sure you'll agree on that one! "

Despite the fact I used to word problem it wasn't meant in an negative way. Credit to AB for involving all of us in the development process, with Microsoft and Oracle for example (not that I'm a MS basher) this sort of process would be going on behind closed doors without the level of input for the development community thats being seen here.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information