Re: SQL*FORM Trigger Question(
From: Joel Garry <tumidity_at_netlink.cts.com>
Date: Wed, 17 Feb 93 10:11:09 PST
Message-ID: <aDo5yB1w165w_at_netlink.cts.com>
Date: Wed, 17 Feb 93 10:11:09 PST
Message-ID: <aDo5yB1w165w_at_netlink.cts.com>
wliu_at_memstvx1.memst.edu writes:
> To update a table ( called table2) outside of current form, I
> wrote a KEY-NEXTFLD trigger(current block: table1):
>
> update table2
> set f2 = :table1.f2
> where f1 = :table1.f1
> commit;
>
Maybe:
set table2.f2 = :table1.f2
?
Just guessing
Joel
-- "See your System Administrator?" I *AM* the #%_at_!?& System Administrator! INTERNET: tumidity_at_netlink.cts.com (Joel Garry) UUCP: ...!ryptyde!netlink!tumidityReceived on Wed Feb 17 1993 - 19:11:09 CET