I haven't tried it. It's a complicated trigger function with updates to other tables that are NOT dynamic in nature. If the EXECUTE statement doesn't set the FOUND variable, then I will be reading the result from a previous operation. I thought maybe somebody would know this already. On Friday 02 September 2005 09:14 am, Michael Fuhr saith: > On Fri, Sep 02, 2005 at 08:51:41AM -0400, Terry Lee Tucker wrote: > > Will the FOUND variable be set, when using EXECUTE, as it would be with a > > normal UPDATE statement? > > What happened when you tried it? > > -- > Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
