Re: ON-INSERT, ON-UPDATE problem in form45
From: X <x_at_x.x>
Date: Thu, 9 Mar 2000 11:43:44 -0000
Message-ID: <8a82ef$1nq$1_at_supernews.com>
Date: Thu, 9 Mar 2000 11:43:44 -0000
Message-ID: <8a82ef$1nq$1_at_supernews.com>
I can't remember if you can do this in Forms 4.5, but in Forms 5 you want to set the 'Lock Record' property of the non-table items that may be changed to 'Yes'.
If this isn't in Forms 4.5, use a WVI trigger to set the record status to CHANGED.
-- -- ==================================== Pete Kolton Oracle Systems Consultant All reasonable offers considered :-) Email: Pete_at_Kolton.com Web: http://www.kolton.com ==================================== Y.S.Huang wrote in message <8a7nqi$4i170$1_at_news.ht.net.tw>...Received on Thu Mar 09 2000 - 12:43:44 CET
>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
>
>
>
>