Re: Update Trigger

Perhaps you can try to use an 'insert into <table2.field> values <:old.table1.field>' construction ?

h.t.h.

In article <8icrcl$bab$1_at_nnrp1.deja.com>,   scott__boucher_at_hotmail.com wrote:
> I am learning triggers. When any field in table1 is updated, I want to
> insert certain data from table1 into table2. Both tables are in the
> same database but have different owners. Table1 has insert rights to
> table2
>
> When table1 is updated do I declare host variables for each field to
 be
> moved to table2 using a select statement and then do an Update with
> these values into table2.
>
> Is there a better(easier) way of doing this.
>
> Thanks
> Scott
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 16 2000 - 00:00:00 CEST