Re: ON-INSERT, ON-UPDATE problem in form45
From: Deana Strbevski <deana.strbevski_at_ina.hr>
Date: Fri, 10 Mar 2000 09:09:02 +0100
Message-ID: <38C8AD9E.4F7B4258_at_ina.hr>
Date: Fri, 10 Mar 2000 09:09:02 +0100
Message-ID: <38C8AD9E.4F7B4258_at_ina.hr>
Hi,
if you use ON- trigger it replace default insert or update.
Insted insert into table1 values (col1,col2,col3....)
forms does what you have wrote.
You can use PRE-insert and PRE-UPDATE trigger. It works.
"Y.S.Huang" wrote:
>
> Hi,
>
> I got a form. With some items which was "base_table" and some was
> "Non_base_table".
> I use on-insert and on-update to save the change of Non_base_table items .
> And If there is no change on base_table items and only items of
> Non_base_table was changed
> ,ON-INSERT and ON-UPDATE will not be trigger.
>
> Is there any one know how to resolve it;
>
> Thanks
>
> mailto: piwu_at_hotmail.com
Received on Fri Mar 10 2000 - 09:09:02 CET