Re: A question about the number of times a trigger will fire

2020-03-05 Thread stan
On Thu, Mar 05, 2020 at 08:58:32AM -0700, David G. Johnston wrote: > On Thu, Mar 5, 2020 at 7:58 AM stan wrote: > > > UPDATE BOM_ITEM SET cost_per_unit = 23.45 , qty = 12345.00 > > > > So, it appears that I need to create a WHERE clause for the resultant > > statement. But I do not see how the f

Re: A question about the number of times a trigger will fire

2020-03-05 Thread David G. Johnston
On Thu, Mar 5, 2020 at 7:58 AM stan wrote: > UPDATE BOM_ITEM SET cost_per_unit = 23.45 , qty = 12345.00 > > So, it appears that I need to create a WHERE clause for the resultant > statement. But I do not see how the function has enough data to use to > create this where clause. > > What am I mis