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
