no trigger . -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Bill Downall Sent: Friday, January 28, 2005 1:50 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: UPDATE COMMAND
Do you have a trigger on that table? Maybe the syntax and the time delay is coming from the trigger. Bill William Owens wrote: >Bill > >I still get syntax error and process seems to hang with hour glass I have to >kill task. When I go back in some ownerids seem to be updated. Very strange > > > >-----Original Message----- >From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Bill >Downall >Sent: Friday, January 28, 2005 1:04 PM >To: RBG7-L Mailing List >Subject: [RBG7-L] - Re: UPDATE COMMAND > > >Bill, > >Try > >update burials set ownerid=t2.ownerid from burials, plotowners t2 where >burials.plotloc = t2.plotloc > >Bill > >William Owens wrote: > > > >>I am trying to update a table "Burials" with an ownerid field from another >>table "Plotowners" >>Both tables have a field "Plotloc" which is a computed field >>I use this command but I get a syntax error Would someone please correct >>me??? >> >>update burials set ownerid=t2.ownerid from burials t1, plotowners t2 where >>t1.plotloc = t2.plotloc >> >>Thanks >> >>Bill >> >> >> >> >> >> > > > >
