Re: Question about calling a stored procedure in a trigger

[Scott Mildenberger <scottmildenberger@xxxxxxxxx>]

I'm not sure what a stored procedure has to do with
this.  You just need a trigger program, there should
be many examples in the archives.  You then compare
the before and after values for the field in question
and then write a record to the other file if they
change.

Scott Mildenberger

--- Giri Gopal <GiriGopal@xxxxxxxxxx> wrote:
>  Hello:
> 
> I am creating a new table called TRANS. I want to
> capture updates to a
> certain column (ORD_NUM). I am planning to put a
> trigger on TRANS table for
> a Update After.
> 
>  Now the question is what would my stored procedure
> look like?, I mean the
> actual code. I need to make sure that the change is
> only to the column
> (ORD_NUM). I need   to compare the before and after
> image of the trigger
> buffer and then write to a new table called
> TRANS_ORD.
> 
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/