Re: ON-INSERT, ON-UPDATE problem in form45

You can try to use the KEY-COMMIT trigger (this trigger will fire each time you press the default COMMIT button in your toolbar) or you can bypass the problem by forcing one of the base table items to be placed in changed mode ==> put the base table record in CHANGED mode when you alter one of the non-base table items.

Regards,

Patrick Dewael

"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 Thu Mar 09 2000 - 11:08:43 CET