Re: Triggers

Rob,

> I have a trigger on a table called stock_count (which has a column
> barcode) which needs to update a value in a table called
> theoretical_stock_count on either an insert,
> update or delete. However, I need to pass the barcode of the
> inserted/updated/deleted row to the function I am calling. Is there
> any
> way to do this?

Within the Update or Delete trigger, the bar code of the original row
is available as OLD.barcode. For Update and Insert triggers, the new
record's barcode is available as NEW.barcode.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco